UNICHAR with Two Codes
Hey all,
I have used the UNICHAR(HEXTODEC("1f310")) to display the emoji of a globe. I want to do the same thing with the American Flag, but the American Flag has two codes.
Any one know how to display the flag emoji using UNICHAR(HEXTODEC()?
=IF(ISBLANK([Import / Domestic]@row), "", IF([Import / Domestic]@row = "IMPORT", UNICHAR(HEXTODEC("1f310")), UNICHAR(HEXTODEC("1f1fa"))))
Answers
-
Hey @Paul Bilbro
I don't personally know the HEX code for the flag, but you could put the actual emoji in the formula in quotes:
=IF(ISBLANK([Import / Domestic]@row), "", IF([Import / Domestic]@row = "IMPORT", UNICHAR(HEXTODEC("1f310")), "🇺🇸"))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hey Genevieve,
Thank you for your response. This works on iPhone (and probably other mobile devices) but on browser this is what I see:
-
@Genevieve P. I think the issue comes down to there not being a USA Flag emoji that is compatible with browsers. US is the default visual representation of the American Flag on a browser ;(
-
Hi @Paul Bilbro
That's really interesting! It works on my Chrome browser:
But you are correct that using emojis in formulas (as well as using UNICHAR in formulas) may not always return the image result.
Please feel free to submit your feature request of having flags as a Symbol Dropdown value to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Interesting, yes on Microsoft Edge, it only shows "US".
Ok I definitely will! Thank you for your help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives