Returning symbol depending of value in cell

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!