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.
Conditional Formatting Based on Date / Number of Days
Options
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
Comments
-
Vincent,
See my comment on this thread:
https://community.smartsheet.com/discussion/conditional-formatting-question
You'll need another (non-date) column to do your calculation then key off that for your conditional formatting.
=IF(TODAY() - [Last Pay Raise Date]23 > 180,1,0)
would work in a checkbox column in row 23.
Craig
This discussion has been closed.
