Syntax
UNICHAR(number)
-
number
—The number to convert into a Unicode character.
Example 1
If the location is UK, show the pound symbol (Unichar value 8356), if the Location is EMEA show the Euro symbol (Unichar value 8364).
IF(Location@row="UK", UNICHAR(8356), IF(Location@row="EMEA", UNICHAR(8364))
Example 2
Replace any adjacent exclamation marks and question marks with the interrobang character (Unichar value 8253).
=SUBSTITUTE(SUBSTITUTE(Text@row, "?!", UNICHAR(8253)), "!?", UNICHAR(8253))
Example 3
Create a list of unique values from a range and list them with an illustrative bullet before each one.
This formula also features the use of CHAR() to add a new line and put each value on its own line in the final result.
=UNICHAR(8608) + JOIN(DISTINCT(Text:Text), CHAR(10) + UNICHAR(8608))
Still need help?
Use the Formula Handbook template to find more support, resources, view 100+ formulas, a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.