ISBlank question
I am trying to return a 0 if my date is blank, if not I want to return a 1 if the date is greater to another date or return a 2 if the date is less than or equal to the other date.
here is the formula I am trying to use
=IF(ISBLANK([Due date]@row, 0, IF([Due date]@row > date@row, 1, IF([Due date]@row <= date@row, 2))))
Best Answer

=IF(ISBLANK([Due date]@row), 0, IF([Due date]@row > date@row, 1,2))
This should work
Yours also works in concept you just put the Parentheses in the wrong place. Need one after the isblank, and then remove one from the end.
Answers

=IF(ISBLANK([Due date]@row), 0, IF([Due date]@row > date@row, 1,2))
This should work
Yours also works in concept you just put the Parentheses in the wrong place. Need one after the isblank, and then remove one from the end.

thank you!!
Help Article Resources
Categories
Check out the Formula Handbook template!