RYGB X Checkbox question

vanzin

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!

 

Chris McKay

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

Andrew Stewart

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.

vanzin

Worked Chris! Ty!

vanzin

Worked Andrew! Ty!

Chris McKay

Any time!