Formatting currency with symblos

Jeremy Oesch

Hello,

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.

JamesB

@Jeremy Oesch Do you already have a formula in you Salary column you can share?