RYGB Based on Text of Another Column

Chris Hallo

Hello, Community! I've seen a few posts but not getting this. I want the Status Indicator column to be:

Red: if Current Status = Delayed

Yellow: if Current Status = At Risk

Green: if Current Status = On Target

Blue: if Current Status = On Hold/Deprioritized

I need help, please!

Andrée Starå

Hi @Chris Hallo

I hope you're well and safe!

Try something like this. You were close. You're referencing the whole column instead of the row.

=
IF([Current Status]@row = "Delayed", "Red", 
IF([Current Status]@row = "At Risk", "Yellow", 
IF([Current Status]@row = "On Target", "Green", 
IF([Current Status]@row = "On Hold/Deprioritized", "Blue"))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kelly Moore

Hi @Chris Hallo

The syntax of [column name]:[column name] makes the statement try to evaluate the entire column looking for, as example, 'Delayed'. Because a column will contain multiple, conflicting answers, the formula will give you an error. You are wanting for the evaluation to occur within a single cell. Since the cells to evaluate are within the same row as the formula, we can use the '@row'

=IF([Current Status]@row = "Delayed", "Red", IF([Current Status]@row ="At Risk", "Yellow", IF(Current Status]@row = "On Target", "Green", IF([Current Status]@row = "On Hold/Deprioritized", "Blue)))

cheers

Andrée Starå

Hi @Chris Hallo

I hope you're well and safe!

Try something like this. You were close. You're referencing the whole column instead of the row.

=
IF([Current Status]@row = "Delayed", "Red", 
IF([Current Status]@row = "At Risk", "Yellow", 
IF([Current Status]@row = "On Target", "Green", 
IF([Current Status]@row = "On Hold/Deprioritized", "Blue"))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Chris Hallo

Thanks, Kelly. I did paste your formula but am still getting #UNPARSABLE:

Chris Hallo

Andrée, thank you SO much :)!

Kelly Moore

oops, I'm missing a parenthesis. For formulas, always check what color the end parenthesis is within the formula. When there is the correct amount, it should be blue. It doesn't mean all the formulas are necessarily in the correct location, but the quantity is correct.

Andrée Starå

@Chris Hallo

You're more than welcome!