Time

NWilliams

NWilliams ✭

12/30/21 in Smartsheet Basics

Hello,

I am curious if there is a way to set a rule of some sort where you can make a row change color if it goes past a lets say 7 day window. Is this possible?

Thank you

0 ·

Answers

hollyconradsmith ✭✭✭✭

12/30/21

Hi @NWilliams,
You can use conditional formatting to do this!
https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?

Help shape the future of Smartsheet.
Share your ideas and feature requests.