Symbols on Forms

Jennifer Parins

If I want to include an available symbol option on a form, I see they automatically include words that describe the meaning of each symbol.

Is there a way to include the symbol without the descriptive words?

Genevieve P.

Hi @Jennifer Parins

There currently isn't a way to hide the text next to a symbol when this column is used in a Form (please submit your Enhancement Request to the Product team through this form, here!)

If you have different descriptors, I would suggest making sure that your "Help Text" under the label in the form explains what you want the symbols to represent. Another option would be to use a text drop-down column and then in your sheet use a formula to translate that into the matching symbol.

Cheers,

Genevieve

Andrée Starå

Hi @Jennifer Parins

I hope you're well and safe!

Here's a possible workaround or workarounds

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/

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!

BESP10

Hi all, I used some emojis for a drop down but they do not show up on the PDF reports even though they show up on the screen, would anyone know why they don't show up when pdfd? @Andrée Starå @Genevieve P. Thanks

Genevieve P.

Hi @BESP10

This is currently expected for emojis. In a similar question we came up with a formula to populate the text word instead of an emoji if that helps, see:

https://community.smartsheet.com/discussion/92685/emoji-showing-on-grid-not-showing-in-print-to-pdf

Itai

@Genevieve P. @Andrée Starå

Is there a way to use these emojis in a formula? such as countif for example?

Andrée Starå

Hi @Itai

I hope you're well and safe!

Yes!

Here's an example.

=COUNTIFS(Emoji:Emoji, "⭐")

Make sense?

I hope that helps!

Have a fantastic weekend & Happy Holidays!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!