Forum Discussion

AndraEcxarcu's avatar
AndraEcxarcu
New Contributor II
2 years ago

Load FX rates through spreadsheet – Workflow time needed

Hello everyone! I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow. I’m using the XFSetFxRate formula, and it works w...
Excel Add In
NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hi AndraEcxarcu !
 I do not know how to do that using the WF Time easily. A simple workaround could be us a native excel dropdown list and point to the result of this drop down list in the XFSetFxRate Formula. That would make it dynamic and you could even add a formula that checks if the time selected is the current month.
Thanks,
Nic