Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

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

Trending in Smartsheet Basics