What is wrong with this AND expression?

AppSheet AppSheet Q&A
1

AND(ISBLANK([Delivered]),ISBLANK([Reason],ISNOTBLANK([Date])))

Error: ISBLANK function is used incorrectly

Expression works fine when I do not have the ISNOTBLANK([Date]) in it.

2

Your expression:

AND(ISBLANK([Delivered]),ISBLANK([Reason],ISNOTBLANK([Date])))

Probably what you want:

AND(ISBLANK([Delivered]),ISBLANK([Reason]),ISNOTBLANK([Date]))
1 Like
3

Ahaa… missing bracket lol

1 Like