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
Suryadhar1's avatar
Suryadhar1
New Contributor
1 year ago

Hi AndraEcxarcu

Assign the Text1 Property of the Spreadsheet component WFTime to |WFTime| and save the file in the 'example.xfdoc.xlsx' format, which is utilized for extensibility documents. In the Excel spreadsheet, enter the time as |WFTime| in any desired cell. When this spreadsheet is accessed in the OneStream application, it will display the Workflow Time.

Thanks,

Surya