Help with a Currency Conversion

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!