RYGB X Checkbox question

vanzin
vanzin
edited 12/09/19 in Formulas and Functions

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!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!