PDF Report

JNash

Hello - I needed to use emjoi for status indicator because we needed more options that were provided in the symbols options. However, when I PDF a report, the status icons are not showing. Is there a way around this?

First image is the report, second image is the PDF of the report.

Brian_Richardson

Are you using the CHAR() function to produce the emojis? With some quick Googling it looks like PDFs in general are hit or miss for supporting emojis depending on how they are encoded.

JNash

No I didnt use CHAR(). I just copy and pasted the emoji. I was able to pull the codes for the colors I need. When I did =CHAR(128308) for red circle, I got #Invalid Value back.

Can you assist me with how to use the =CHAR() formula to get the color icons to show? Thank you.

Brian_Richardson

I found a list of unicode characters at the link below. Some of them are hit or miss, Smartsheet doesn't support every single character but I've found that many of them work. The "Emoticons" and then "Misc Symbols" section has most of the colorful emoji type characters.

https://www.vertex42.com/ExcelTips/unicode-symbols.html#control