Is it possible to create an additional list of symbols? Need to add ORANGE below.

Wind guy

Wind guy

That did it, I had no idea you just put in the "icons", I was under the impression that it had to align with the cell properties such as "status". Thank you very much for the prompt support!

Andrée Starå

@Wind guy

Excellent!

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!

Nik Fuentes

I'd love to second that, or at least request the ability to customize a set from the index of symbols that exist. That would be nice.

Andrée Starå

Hi @Wind guy

I hope you're well and safe!

You can use other symbols by using UNICHAR, CHAR, or Emojis.

More info:

https://help.smartsheet.com/function/unichar

https://help.smartsheet.com/function/char

https://getemoji.com/

A great resource that Paul Newcome put together

https://app.smartsheet.com/b/publish?EQBCT=82f8fe0936a54758a3afa4b584acde07

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

Wind guy

@Andrée Starå @Nik Fuentes 

Thanks for the support. If I am understanding correctly, I do not think CHAR will work as this is one of multiple versions of a sheet that all report into one dashboard, each sheet used by different personnel on diff computers so characters may vary.

For UNICHAR can you give an example of Fx based on the following:

=IF([Weekly Status Update]@row = "Delayed", "Red", IF([Weekly Status Update]@row = "Awaiting Stakeholder", "Orange", IF([Weekly Status Update]@row = "Not Started", "Yellow", IF([Weekly Status Update]@row = "In Progress", "Green", IF([Weekly Status Update]@row = "Complete", "Blue")))))

Thanks in advance!

Andrée Starå

@Wind guy

Happy to help!

Try something like this.

=IF([Weekly Status Update]@row = "Delayed", "🔴", IF([Weekly Status Update]@row = "Awaiting Stakeholder", "🟠", IF([Weekly Status Update]@row = "Not Started", "🟡", IF([Weekly Status Update]@row = "In Progress", "🟢", IF([Weekly Status Update]@row = "Complete", "🔵")))))

Did that work/help?

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

Wind guy

That did it, I had no idea you just put in the "icons", I was under the impression that it had to align with the cell properties such as "status". Thank you very much for the prompt support!

Andrée Starå

@Wind guy

Excellent!

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!

Julie Becker

Maybe this would be helpful or maybe not, but here is what i did

I used the links below to make my own drop-down symbols (I replace the emoji code name in the formulas if used in place of Harvey balls). I tested them in formulas (some work, some do not) and now use in our sheets.

Here are a few images to show you them in action. Not sure if this is what you're after, though...

https://emojipedia.org/symbols

https://emojipedia.org/objects

https://emojiterra.com/