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

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Alex Vorobiev

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

formatting - select criteria.png

formatting - define custom criteria.png

Vanessa_SOS

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!