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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!