Symbol Forumula Help Please

Justin Tackitt
Justin Tackitt ✭✭✭✭

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


  • Justin Tackitt
    Justin Tackitt ✭✭✭✭
    Answer ✓

    Please disregard - I had 1 too many brackets at the end 🤨

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Justin Tackitt

    Good spot! I'm glad you figured it out.

    Just a small note, since you only have two actions (either Red or Green), you can actually just use one IF statement for this.

    You could say, if the box is checked then it's Green, otherwise, it would be Red, since if the box isn't checked then it has to be un-checked.

    Try this:

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