nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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?

Comments

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

Sign in to join the Community!

Quick Links

Find more posts tagged with

Human Resources

Construction

Conditional Formatting