Currency Conversion USD to CAD

Hello

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.

Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!