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 155
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