|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Is it a possible to duplicate a sheet using chains?

Richiedi una demo

I have a template in a sheet with the formulas referencing to other sheets. Is it possible to duplicate the sheet and change the formulas references using chains? Manually, we can duplicate the sheet and use the replace all function to change the references. I have gone through APIs but I couldn't find any.

0

Commenti

2 commenti

Data Voti
  • Isabel Messore
    Currently, Workiva does not have a direct connector command in Chains to duplicate a sheet while maintaining its formatting, formulas, and settings. However, there is a workaround using an API with an HTTP POST command to copy the sheet, including its formatting, locked cells, and formulas. You can refer to the API documentation for more details: https://developers.workiva.com/workiva-platform/reference/platform-copysheet .
     
    There's also an existing feature request for a new Workiva command to copy sheet with formatting, formulas, and settings that I can add you to!
    0
  • Jeff Hickey

    Hi Pavan Kapalavayi, you may want to try Initiate a File Copy. This endpoint copies a file and can copy the formulas, including formulas that reference other Sheets within the Spreadsheet.

    0

Accedi per aggiungere un commento.