Data type mismatch: format other than LIST or DATE being referenced as a relation

anandksahay
New Contributor

Data type mismatch: format other than LIST or DATE being referenced as a relation

any suggestion on how to resole above error

 

1 REPLY 1
TimWard70
Contributor

Re: Data type mismatch: format other than LIST or DATE being referenced as a relation

Looks like the line item you are referencing in a SUM, SELECT or LOOKUP formula is Text or Number formatted.  Change the line item that is being referred to so that it is LIST or DATE formatted.  If it is currently TEXT then a FINDITEM might be helpful.