How to automatically check a checkbox ?

Hi !

I'm looking for the formula to automatically check a checkbox (Column named Urgent) when the due date has passed (Column name Deadline). The column Urgent is a checkbox column and the column Deadline is a date column.

I would like that, when the date in the Deadline is passed, I want the Urgent box to be ticked automatically.

Can someone help?

Thanks in advance.


Best Answer

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Answer ✓


    The formulas that have been provided work for me. Double check the column properties and see if changing the 1 and 0 to true and false does anything. If not, provide a screenshot similar to the one below.

    =IF(Deadline@row < TODAY(0), true, false)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!