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?

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

2 Likes

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

2 Likes