UNICHAR with Two Codes

Paul Bilbro

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"))))

Genevieve P.

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

Paul Bilbro

Hey Genevieve,

Thank you for your response. This works on iPhone (and probably other mobile devices) but on browser this is what I see:

Paul Bilbro

@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 ;(

Genevieve P.

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

Paul Bilbro

@Genevieve P. Interesting, yes on Microsoft Edge, it only shows "US".

Ok I definitely will! Thank you for your help!