Conditional Formatting Based on Date / Number of Days

Vincent Forte

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?

J. Craig Williams

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