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