Load FX rates through spreadsheet – Workflow time needed

[AndraEcxarcu]

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 when I hard code the time, for example ‘2020M1’. However, I need the time to be dynamic, to change based on the workflow.

Is there a way to bring the Workflow time in the XFSetFxRate formula? I tried WF and WFTime, but it doesn’t work.

Thanks!

[NicolasArgente]

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

[AndraEcxarcu]

Hi @NicolasArgente !

Thank you for the reply. 

Yes, this is one solution, initially I didn't want the user to have to select anything in terms of time 😞 But if there is no other workaround, I guess I'll have to do it this way. 

Thanks!