How to connect symbols with text

SIS

Hi,

I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change the status of the project.

Please see the attached screenshot.

Symbols and Texts.PNG

hollyconradsmith

Hi @SIS,

You could use an IF formula in the symbol column.

For instance:

=IF(status@row="Not Started", "Grey", IF(status@row="In Progress", "Green", ...etc

Is that what you are getting at?

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

hollyconradsmith

Hi @SIS,

You could use an IF formula in the symbol column.

For instance:

=IF(status@row="Not Started", "Grey", IF(status@row="In Progress", "Green", ...etc

Is that what you are getting at?

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

SIS

Thanks, Holly! Just found out another way to do it. Just used emoji along with a text! That worked a charm. Thanks for your help!