Using Emojis in Smartsheets

We want to use icons that relate to our work. I have an IF formula that includes emojis.

=IF(Classification4 = "BAGS", "🎒", IF(Classification4 = "SOCKS", "🧦", IF(Classification4 = "GLOVES" = "🧤", IF(Classification4 = "BALLS", "⚽️", IF(Classification4 = "PROTECTIVE", "🛡", "")))))

For some reason, the "BAGS"🎒and "SOCKS" 🧦 emojis show up, but the "GLOVES", "BALLS", and "PROTECTIVE" emojis do not?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!