Trying to connect checkboxes to colors

Taylor-Pittman
edited 12/09/19 in Smartsheet Basics

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!

Comments