RYGB X Checkbox question
Hello again Community!
I currently use the following formula for our projects: (Works well!)
=IF(Finish15 <> 1; IF(due_date15 - planned_date15 > 0; "Red"; IF(due_date15 - planned_date15 > -3; "Yellow"; "Green")))
But now I would like to include a blue ball when the "finish" checkbox is checked.
I tried some alternatives, but I did not succeed. Can anybody help me?
Thanks!
Comments
-
Hi vanzin,
If you have a single "outlier" condition, I generally include it at the front of the formula to get it out of the way:
=IF(Finish15, "Blue", IF(Finish15 <> 1, IF([due_date]15 - [planned_date]15 > 0, "Red", IF([due_date]15 - [planned_date]15 > -3, "Yellow", "Green"))))
You also had some errors in the formula (; instead of ,) that I cleaned up.
Hope this is what you were after.
Kind regards,
Chris McKay
-
Hi Vanzin,
Semi colons don't work for my locale, but I believe the only change you need is:
=IF(Finish15 <> 1; IF(due_date15 - planned_date15 > 0; "Red"; IF(due_date15 - planned_date15 > -3; "Yellow"; "Green"));"Blue")
in other words add in the value_if_false parameter for the first IF statement.
-
Worked Chris! Ty!
-
Worked Andrew! Ty!
-
Any time!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!