The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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