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.

0 3 378
3 REPLIES 3

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

Steve
Platinum 4
Platinum 4

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.

Top Labels in this Space