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
Check out the Formula Handbook template!