RGY Balls and Days remaining
Currently, I am using this formula
=IF([End Date]396 < TODAY(), "Red", IF([End Date]396 = TODAY(), "Yellow", IF([End Date]396 > TODAY(), "Green")))
for health status.
What I would like to do is tweak this, so that if a task is less than 75%, and due in 3 days, the ball is YELLOW. Everything else remains the same
Comments
-
Taking a bit of a guess with what you need..
- If % complete is 100 % then GREEN
- If it was due yesterday (or later and is not done) the RED
- If it is due between today and 3 days from now and under 75% it is YELLOW.
- If it is due today to 3 days from now and equal to or over 75% it is GREEN
- If it is due past 3 days from now it is green
=IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF(AND([End Date]@row < TODAY(3), [% Complete]@row < 0.75), "Yellow", "Green")))
- In your scenario even if the task is done it will show red as soon as it falls in the past
- Do you want tasks that are not done in the future showing green or just blank?
- I would probably have it show nothing and green within the 3 days
Below will accomplish that
=IF([% Complete]@row = 1, "Green", IF([End Date]@row < Today(), "Red", IF(AND([End Date]@row < TODAY(3), [% Complete]@row < .75), "Yellow", IF([End Date]@row < TODAY(3), "Green", ""))))
- If % complete is 100 % then GREEN
- If it was due yesterday (or later and is not done) the RED
- If it is due between today and 3 days from now and under 75% it is YELLOW.
- If it is due today to 3 days from now and equal to or over 75% it is GREEN
- If it is due past 3 days from now it is BLANK
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives