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 177
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