Symbol Forumula Help Please

I have a sheet where I track the progress of 4 steps for multiple projects. Each project has it's own row and the 4 steps are in 4 separate columns. Each step has a check box and when that step is complete the box is checked which in turn triggers an automation that populates the date each step was checked. I am trying to get a symbol to populate in a new column that shows red for the boxes that are not checked and green for the boxes that are checked.

I came up with the formula below but it's not working. I'm using 1 for checked and 0 for unchecked. Any help would be greatly appreciated!!

=IF([LS Drawing Redlines Complete]@row = 1, "Green", IF([LS Drawing Redlines Complete]@row =0, "Red")))

Best Answer

Answers