Change date color beyond certain time period

Hello!

This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed.

For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like it to change to orange. Over 90 days, I would like it to change to red. I would also like to do this without adding another column if possible.

Does anyone know if this doable? I've had no luck searching around the forms and feel like I'm missing something obvious. The attached image shows my current column on the left, and how I would like it to look on the right.

Thanks!

Find more posts tagged with

color

dates

update column

Accepted answers

A Goodman

Was able to solve from this thread:

Conditional Formatting based on Date — Smartsheet Community

Have to cheat the last rule but it works just fine.

All comments

Naeem Ejaz

Yes, this is absolutely doable in Smartsheet using Conditional Formatting, and you can achieve this without adding any helper columns. Here's a step-by-step guide to set it up so that the date cell changes color based on how many days ago it occurred:

Open your sheet.
Go to “Conditional Formatting” (from the toolbar or dropdown under "Format").
Click “+ New Rule.”

🔸 Rule 1: Over 90 Days → Red

When: [Your Date Column]
Condition: is in the past AND
=TODAY(-90) (see below)
Custom Formula:
Choose "Date is in the past"
Then use "More than" → 90 days

✔ Format: Red Fill

🔸 Rule 2: Over 60 Days → Orange

Same setup, but:
Condition: "More than 60 days"

✔ Format: Orange Fill

🔸 Rule 3: Over 30 Days → Yellow

Condition: "More than 30 days"

✔ Format: Yellow Fill

🔁 Important Rule Order

Smartsheet applies rules from top to bottom, so make sure you arrange them like this:

Red (90+ days)
Orange (60+ days)
Yellow (30+ days)

🔄 If Yellow is on top, it will override Red/Orange unless you re-order.

A Goodman

Was able to solve from this thread:

Conditional Formatting based on Date — Smartsheet Community

Have to cheat the last rule but it works just fine.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.