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?
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
