Conditional formatting for dates that are X amount of time in the past

I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another sheet.

Currently there is only a function for "in the past" without any way to add to the formula how far in the past. It would be extremely helpful to have the ability to set parameters on past dates.

Sign in to vote!

Find more posts tagged with

Formulas

Idea Submitted

Conditional Formatting

Workflows in Smartsheet

Comments

Pam Grant

Idea: I need to highlight the cell if it is more than X days old.

Background:

Currently, we can format if the cell date is in the next X days or in the past X days.

I don't want to create a new column that subtracts today from the recorded date to get a number for conditional formatting.

Arundhati

I agree with this. Added flexibility for conditional formatting will be very useful, especially with dates.

crioux

Just pinging this idea. There was an archived suggestion for this in 2016. Seems odd this hasn't been implemented given it's easy to do an automation for items more than x days in the past.

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.