For expenses sheets it would be very useful to lookup fx rates based on the expense date for calculating local currency to reference currency amounts easily.
Thanks
There is no way generically to do this. The only way would be to create an app that access the Smartsheet API and also the Exchange rate source that you need to use.