Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Maintain/Define value formatting in rollforward chain

Answered
Request Demo
  • Edited

Hi team,

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.

0

Comments

1 comment

Date Votes
  • Wayne Paffhausen
    • Edited

    Hello Krishma Gupta,

    As mentioned in other posts related to Spreadsheets the formatting is not an option when copying data between spreadsheets currently.  The Write Sheet Data only stores the data not the format of the data.

    At the time of writing this response the ability of formatted values is being reviewed currently as an enhancement to better support this type of workflow.

    0

Please sign in to leave a comment.