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.
Setting a conditional format when a date is e.g more than a week ago??
Hello all
I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business.
I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold.
I can't seem to do this with the conditional formatting built into smartsheet, can someone please tell me if this is possible?
Β
e.g Todays date is 19th Feb, the date on this column is 10th Feb (i.e more than 7 days ago), I want the cell to automatically highlight red until the responsible person changes the date.
Β
Many thanks in advance!
Comments
-
Chloe,
Β
Unlike other conditional formatting options (for other column types), we don't have a "when condition is NOT met" option. That would allow us to solve this problem without a formula.
Β
However, we can't so you'll need to create a column to determine if the criteria is met.
I woud use a CheckBox column and this formula.
Β
=IF((TODAY() - [Particular Date]23) > 7, 1, 0)
Β
My date column is named [Particular Date] and the formula is looking to the date on row 23.
Β
Key the conditional formatting for when the check box is checked.
Β
Hope this helps.
Β
Craig
