Formula for Symbols

Carlos Yanes

Hi all,

I need some help creating a formula that will auto populate a symbol field with a color based on what is listed in a different column/row which contains a status.

Blue - Complete

Green - On Track

Yellow - Not Confirmed

Red - Off Track

It would be reading off a column called "Stage".

Thank you!

Nic Larsen

=IF(Stage@row = "Complete", "Blue", IF(Stage@row = "On Track", "Green", IF(Stage@row = "Not Confirmed", "Yellow", IF(Stage@row = "Off Track", "Red", ""))))

Nic Larsen

=IF(Stage@row = "Complete", "Blue", IF(Stage@row = "On Track", "Green", IF(Stage@row = "Not Confirmed", "Yellow", IF(Stage@row = "Off Track", "Red", ""))))

Carlos Yanes

Thank you @Nic Larsen !