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

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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.








  • Alex Vorobiev
    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!

This discussion has been closed.