Calculate a conversion rate on a specific date

edited 12/09/19 in Formulas and Functions

I have a budget that has expenses in both USD and EUR.

I report expenses in USD to our finance department.

I'd like to be able to calculate the euro to usd conversion rate for the date that something is paid. Is there a formula not to pull the current conversion rate, but a conversion rate from a specific date, in this instance the paid date?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!