How to convert USD to Canadian Dollars format in Smartsheet ?

Deepali Bhardwaj

Please help me to figure how to convert USD to Canadian Dollars format in Smartsheet ?

Also, does it depend on user setting or sheet settings?

Mark Cronk

Good evening,

Try changing your language settings, below.

https://help.smartsheet.com/articles/796268-adjusting-personal-settings

Mark

Deepali Bhardwaj

Hey Mark,

Based on your solution, I tried to change Personal Settings and found following for Toronto Time zone.

Is this the reason my file is showing USD$ values ?

Also, would like to know how can this be fixed ?

Thank you!!

Mark Cronk

The time zone and regional settings in your personal account are supposed to set number formats. There isn't a Canadian region so I'm curious to find out if the Toronto time zone changes the currency. Let me know.

Mark