Conditional Formatting Question
Good morning,
I have a column within my Project Schedule Management spreadsheet that tracks the "Health" of a task. It currently conditionally formats the color of the "Health" symbol based on the formula:
=IF([Start Date]87 > TODAY(), "Blue", IF(AND([% Complete]87 < 1, [End Date]87 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green")))
Can anyone tell me how to modify the formula to change the color of the health symbol to "Red" when the End Date is within 60 days of TODAY's date?
Thanks!
Best Answer
-
Try this:
=IF([Start Date]87 > TODAY(), "Blue", IF(AND([% Complete]87 < 1, [End Date]87 > (TODAY() - 60)), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green")))
BRgds,
-Ray
Answers
-
Try this:
=IF([Start Date]87 > TODAY(), "Blue", IF(AND([% Complete]87 < 1, [End Date]87 > (TODAY() - 60)), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green")))
BRgds,
-Ray
-
Thanks very much, Ray.
Jim
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives