What could be wrong with this case formula?

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I think I may have an issue with the operator like < I am using. Tried putting it in quotes but no luck. 


Case(

[Weeks To Site Start],

22, "Master Survey Due Now",

20, "Safes, trolleys, and Primary Take Off due now",

<20, "No action necessary"

)

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

  • 1
  • 1
You can't use arithmetic expressions with Case it can only check for a single value matching exactly.

You will need to use a regular IF statement.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks.