What is wrong with this AND expression?

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.

Solved Solved
0 2 152
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Your expression:

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

Probably what you want:

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

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

Your expression:

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

Probably what you want:

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

Ahaaโ€ฆ missing bracket lol

Top Labels in this Space