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
5 months 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