Expression Assistant says my expression is valid but get an error

IFS([IS_GEO]=“FALSE”,“FALSE”,
(ISBLANK([GEO_NO])),“FALSE”,
AND([IS_GEO]=“TRUE”,NOT(ISBLANK([GEO_NO]))),“TRUE”)

What am I doing wrong? Why would the Expression Assistant say it is valid when the app doesn’t like it?

Solved Solved
0 2 173
1 ACCEPTED SOLUTION

Try removing the quotation marks around all the TRUEs and FALSEs. You’re returning strings while the SHOW_IF expected a Boolean.

View solution in original post

2 REPLIES 2

Try removing the quotation marks around all the TRUEs and FALSEs. You’re returning strings while the SHOW_IF expected a Boolean.

Thanks for the answer and an extremely quick response. I appreciate it.

Top Labels in this Space