Formatting currency with symblos


I am working on a smartsheet and need to know how to have to currency symbol automatically added based on the "Departure Country".

I have two rows a Salary row and a Departure Country row. I need the Salary row to have the correct currency symbol based on the departure country which can be any country. PLease help me create a formula for this or if there is an easier way please let me know.

For example if the departure country is "United Kingdom" then I need the Salary row to say £100,000.00 but if it is germany then i need it to say €100,000.00.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!