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

anandksahay
anandksahay
in Modeling

any suggestion on how to resole above error

 

Tagged:

Answers

  • TimWard70
    TimWard70

    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.

  • SPLASHIMAGE
    SPLASHIMAGE
    Thanks, it worked
  • nikhilkumar1602
    nikhilkumar1602

    Thanks, it worked  👍

Categories