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.
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale.
However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
Comments
-
I think it's a great feature to request! In the meantime, I can think of at least two workarounds:
1) Format everything in your column or sheet to have a red background (or whatever you want the "late" color to be). Then, in your conditional formatting, have it change the cell background to the normal white color if it's "In the last 30 days." It's kind of backwards thinking, but should technically produce the desired effect.
2) Create a new column solely for calculating the age of a task. Your formula could look something like "=TODAY() - [Date Column]1". Then, apply your conditional formatting to the desired cell/row based on the value in this column if the value is bigger than 30.
-
Thanks Greg. You nailed the two ideas our team came up with. Gives me great confidence we're doing all we can until they add that as a feature.
-
Hi D-- This is on our enhancement request list and I'll add your vote for it. In the meantime, Greg has provided two great workarounds--thanks for sharing those, Greg!
-
Add my vote as well please.
Thanks!
-
Has this enhancement been added since this post? If not, can you add my vote as well.
-
Has anyone found out if they have added this feature yet?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives