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.
Enhancement Request: Allow "when condition is not met" for Date columns
In order to do some common date related conditional formatting (for example, aging or older than 7 days ago https://community.smartsheet.com/discussion/setting-conditional-format-when-date-eg-more-week-ago), we need to create a formula.
This could be avoided if we had the same functionality for dates that we have for other column types.
My assumption is that the browser processing time for conditional formatting vs additional cells and formulas would be comparable.
Is it?
If not, is there is another reason why this design decision was made that can be shared to us?
There are many posts asking for solutions that require the add-a-column-and-formula work-around.
Craig
Comments
-
Craig - great question. The right-hand pane provides two modes - "select criteria" (also sometimes called "select from list") and "define custom criteria" (please note that you need to have data in the column for the "select criteria" mode to show up.
So, as long as you are in the "select criteria" mode (which is basically multi-selecting from a list of existing values), you will have the negation option available at the bottom:
Does that address your need? Tx
-
We want this feature, too. We need a custom criteria for a date column that allows for "is AFTER the next (days)". You could also add the "if not met" option to the custom criteria area and this would allow for the same functionality.
Thanks for your consideration!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives