Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How do I auto check a box based on a date + x # of days?

Steve Powers
edited 12/09/19 in Archived 2017 Posts

Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column.  I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick box.

What I am trying to do is get a deposit date looked at against an all items received column and then check a box if its is past 4 weeks and the items have not all been received.  This can then trigger a conditional format to change the row to bold red or something simialr to draw attention to it.  

Is this possible and what would the formula be? 


  • Steve,

    In the column with the checkbox you can use an =IF statement.  Check = 1, Not Checked = 0.


    =IF([Date]1 + 28 < Today(), 1, 0)  

    Then you can set up your conditional formatting.

    Good Luck



This discussion has been closed.