Help with a Currency Conversion

laurenceharper
edited 12/04/21 in Formulas and Functions

Hi there, wondering if anyone can assist....

I am looking for a way to take various native currency amounts in say 2 separate columns (i.e. USD and EUR) - when I enter a respective amount a formula automatically takes that value, changes it to GBP in a separate destination column cell. The exchange rate can be a fixed rate - say USD to GBP being 0.72 for example.

Many thanks

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!