I am using chains to rollforward historical data. Below is the screenshot of my chain.
The rollforward works fine but I am facing issue with the formatting of the text. It seems the Write Sheet command sets the formatting to ones. Is there any way to avoid this or any other additional steps I can add to my chain to define the format of the cells to millions or date (year)
Snapshot of the Spreadsheet data after rollforward.