Formula to check off a box if date is in the past and not blank

This is one of the formulas I've tried:

Thanks for your help!


Best Answer

  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭
    Answer ✓


    This should work for what you have described:

    =IF(ISDATE([Date to Deactivate]@row), IF([Date to Deactivate]@row < TODAY(), 1, ""), "")

    I hope that helps.

    Thank you,


    Happy to help if I can.

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!