Hi there, I 'am trying to make an expression...

expressions
(Abel Torregosa) #1

Hi there,

I 'am trying to make an expression that will show only the specific value from column A with null value at column B. Example: Column A is the

Application Status with data “Rejected” or “Approved” Column B is the

Inspection Status with Null data.

What is the possible formula/expression to be used in order to select on those data?

Best regards!

(Praveen Seshadri (AppSheet)) #2

Are you looking for a filter expression to match such rows?

AND( [Column A] = “Rejected”, ISBLANK([Column B]))