Returning symbol depending of value in cell

Swescan Info

Hi,

I have a column which shows the current status of a project depending of a numerous other cell values. The status is shown in text, but I would like it to be more visual and thought of using the resource symbols as a visual for the different toll gates that the project has gone through. And then just simply hide the text version of the Status cell.

Depending of the value of the "Status cell" I would like a column that show me one, two, three people and so on, but can't get a formula to work.

This is probably simple if you know it but I can't figure out how to write the IF with numerous text options.

Andrée Starå

Hi @Swescan Info

I hope you're well and safe!

Try something like this.

=
IF(Status@row = "Not started", "One", 
IF(Status@row = "Process 1 complete", "Two", 
IF(Status@row = "Process 2 complete", "Three", 
IF(Status@row = "Delivery ready", "Four", 
IF(Status@row = "Invoice", "Five")))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Swescan Info

Thank you very much!

Have a nice weekend!

Andrée Starå

@Swescan Info

You're more than welcome!

✅Remember! 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!