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

Uploaded Dec 29, 20217.01 KB

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?

Available Symbols in the Symbols Column | Smartsheet Learning Center

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

The Symbols column displays an image to convey a meaning.

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?

Available Symbols in the Symbols Column | Smartsheet Learning Center

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

The Symbols column displays an image to convey a meaning.

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!