RAG Symbols Column Changed From A Project Status

CAS

Hi,

I want to have a RAG column change the symbols dictated from the Project Status in a formula but can't work it out.

Example

Project status is 6 - IBM PO Inhand

RAG Symbol should turn to Green

I have a RAG column setup with the red, amber & green symbols.

Any help would be appreciated?

Lidiya S.

Craig,

It is definitely possible to accomplish this! Could you share some more info on the use case? How many different project statuses should be red, how many green, how many amber?

In general I would use the following formula in the RAG column as a column formula:

=IF([Your Project Status column]@row = 6, "Green", IF([Your Project Status column]@row = 0, "Red", "Yellow"))

Or, if you are looking for a status on the entire sheet instead of a specific row:

=IF([Your Project Status column] = 6, "Green", IF([Your Project Status column] = 0, "Red", "Yellow"))

Pretty much say "If status is 6, then show Green, otherwise if status is 0, then show Red, otherwise show Yellow".

Just an FYI Smartsheet uses the nomenclature (Red,Yellow,Green) for the status ball symbols.

Hope this helps!

Lidiya Shutaya

lidiya@ddbconsultants.ca