Past Due date
I am trying to figure out a way to high light the row, when the date requested has passed it 7-day return. Even if date receive is blank, I want it to highlight the row because the current has been more then 7 days. Currently on the duration we have it counting once we enter the date receive. I don't have it highlight when it's been more then 7 days.
Answers
-
Hello @Christina v,
I would suggest creating a helper column with a formula that will tell you how many days have passed, and then you can set up a Conditional Formatting rule based on that column.
For example: You could use the below formula, and then set a formatting rule that will highlight the row yellow if the helper column is greater than 7.
=TODAY() - [Date Requested]@row
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!