Currency Conversion USD to CAD

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Currency Conversion USD to CAD


I am currently using both currencies in my sheet.

I created a column drop down, need help with a formula.

If I select USD from that column, the amount should be converted to CAD if I select CAD from that drop down column then the amount should remain same.


Best Answer


Sign In or Register to comment.