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.