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

any suggestion on how to resole above error




  • 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.

  • Thanks, it worked
  • Thanks, it worked  👍