Conditional Formatting based on Dates
Is there a way to have the system highlight using Conditional Formatting when it's past a number of days?
Yellow when it's 30 days after "booked date"
Orange when it is 45 days after "booked date"
Red when it is 60 days and older after "booked date"
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
Best Answer
-
Try this...
=IF(TODAY() > [Booked Date]@row + 60, "Red", IF(TODAY() > [Booked Date]@row + 45, "Orange", IF(TODAY() > [Booked Date]@row + 30, "Yellow")))
Then you can set up your conditional formatting to highlight your column(s) based on the text value in this column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hi @Joe Goetschel
Hope you are fine, you can create a helper column calculatin how many day past the booked day and create your Conditional Formatting rule using this helper column:
past days = today() - booked date
then you create the Conditional Formatting rule
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
How would the formula read? I can do a DATEONLY to get the correct dates for each level in 3 different columns.
=DATEONLY([Proposal Delivery Date]@row + 30)
=DATEONLY([Proposal Delivery Date]@row + 45)
=DATEONLY([Proposal Delivery Date]@row + 60)
Is there an IF I can do that takes all of these and have it give me 0, 30, 45, 60?
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Try this...
=IF(TODAY() > [Booked Date]@row + 60, "Red", IF(TODAY() > [Booked Date]@row + 45, "Orange", IF(TODAY() > [Booked Date]@row + 30, "Yellow")))
Then you can set up your conditional formatting to highlight your column(s) based on the text value in this column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you @Paul Newcome that did the trick!
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives