Trying to connect checkboxes to colors

Taylor-Pittman · 10/18/19

Hi there-

I am trying to make a "status" column turn green or yellow based on a check box in the spreadsheet.

Basically when the "checkbox a" is checked ("true") I want it to turn my status to "Yellow". When the other box "checkbox b" is checked ("true") I want the status to turn "Green".

Here is what I have so far- =IF(FIND("true", [SOs Created]5), "Yellow", FIND("true", [Job Completed]5), "Green")

Any help would be greatly appreciated!

Thanks!

L_123 · 10/18/19

=if([SOs Created]@row = 1, "Yellow", if([Job Completed]@row = true, "Green"))

Taylor-Pittman · 10/18/19

This is working! However, I need the green to happen when both checkboxes are marked true.

So if I check the first box it turns yellow, YAY! But, in order for the other one to make the status green you have to uncheck the first box.

Thanks!

Andrée Starå · 10/21/19

Hi Taylor,

Try something like this.

=IF(AND([SOs Created]@row = 1; [Job Completed]@row = 1); "Green"; IF([SOs Created]@row = 1; "Yellow"))

The same version but with the below changes for your and others convenience.

=IF(AND([SOs Created]@row = 1, [Job Completed]@row = 1), "Green", IF([SOs Created]@row = 1, "Yellow"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Taylor-Pittman · 10/21/19

Andree-

The second one worked!

Thank you so much for your help!!!

Taylor

Andrée Starå · 10/21/19

Excellent!

Happy to help!

Trying to connect checkboxes to colors

Comments

Categories