7

I am sure I have seen a Smartsheet trainer change the names of symbols but from what I can research, this remains a request unresolved for a number of users.

This should be a simple thing without needing to apply formulas etc.

Can anyone help?

Comments

Hi,

Can you describe your process and what you want to do in more detail and maybe share a few screenshots? That would make it easier to help. 

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Hello Andree,

We simply want to use some o the standard symbols e.g. tick (Yes), cross (No) and change the word 'Yes' to 'On time' and the 'No' to 'Late'

 

Trust that clarifies.

Regards

In reply to by TeeM

Thanks!

If I understand your need correctly, then the below formula should work.

Try this.

Put the formula in the Symbols Column and reference the Status column.

=IF(Status@row = "On Time"; "Yes"; IF(Status@row = "Late"; "No"))    

The same version but with the below changes for your and others convenience.    

=IF(Status@row = "On Time", "Yes", IF(Status@row = "Late", "No"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée

We just have a single column with the symbol. Are you saying we need 2 columns to do this?

In reply to by TeeM

Yes, as far as I know, it's not possible to change what the symbols are named, and if you have a formula in the symbol cell and then write something in it, the formula will be replaced and deleted.

Hope that helps!

Best,

Andrée

Thanks once again Andreesmiley