Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
Is there a way we can implement a currency conversion feed into Smartsheet? (I'm sure there's a coded way to workaround this, but looking after global accounts - I'd much prefer using an official and reliable tool within Smartsheet.
Thanks,
Matt
@darkmatter In the interim, you can try poking around the below workaround. Better audit transparency leveraging OneDrive (or SharePoint), Data Shuttle and Data Table. 1) XLSX template hosted on OneDrive or SharePoint 2) Morning sweep Power Automate Cloud Flow ingests FX Rates from source 3) Power Automate Cloud Flow posts FX Rates to the XLSX template in OneDrive or SharePoint 4) Create Smartsheet Data Table 5) Smartsheet Data Shuttle Uploads OneDrive FX Rate XLSX into Data Table 6) Data Table Connection to Smartsheet Grid 7) Nightly sweep of data in XLSX template to Archive XLSX hosted in OneDrive or SharePoint
thank you Erin. Great inspiration for a workaround.
Many organisations operate across multiple markets and currencies. Whilst there are technical workarounds available, it would be valuable to have a native currency conversion capability within Smartsheet, powered by a trusted exchange-rate source.
This would support financial reporting, forecasting, budgeting, project tracking, and global account management, whilst reducing reliance on external integrations and manual updates.
For enterprise customers managing global programmes, an officially supported solution would improve consistency, reliability, and governance.
FYI @Erin Horiuchi Green
Sign in to comment or add your vote.
