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

  • Samuel Mueller
    Samuel Mueller Overachievers
    edited 04/19/22 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!