Expression Assistant is not detecting an expression with incorrect bracket placement

“Issued By” is a column and when
ISBLANK([Issued] By)
is entered, the assistant will show it as OK.

I have noticed other instances where this sort of silent failure happens in the expression assistant.

Notice the Expression Assistant interpretation:

("[Issued] By") is empty

In certain cases where Expression Assistant can’t quite figure out what it’s looking at, it falls back to treating the input as Text. In this particular case, Expression Assistant interpreted what you entered as:

ISBLANK("[Issued] By")

which is a valid expression.

I think it should be strict in this case. The typo will lead to treating the expression as always TRUE.

1 Like