Automate

 View Only
  • 1.  Multiple Sheets in Data File For Studio

    Posted 07-23-2025 11:24

    Hello Community!

    As we are acquainting ourselves with our new Automate Studio setup, a question has come up a couple times: is it possible to use multiple sheets in the same Excel workbook/data file?

    We are wanting to put the Extended Log in another sheet than the main sheet where Runners are doing their data entry. 

    Has anyone successfully been able to pull something like that off, or have any tips and tricks for adding more than one sheet in a data file?

    Thanks in advance for your suggestions! 



    ------------------------------
    Samuel Varney
    Cooperative Regions Of Organic Producer Pools
    ------------------------------


  • 2.  RE: Multiple Sheets in Data File For Studio

    Employee
    Posted 07-24-2025 18:50

    Hi Samuel

    This is not currently possible.

    The only option we have to multiple sheets is a multi-sheet loop where the header information is on one sheet and details on another.  Each sheet has to specify a "key" to match them up, i.e. this header goes with these detail lines.

    If the goal is to have a separate sheet for inputs and another sheet to load the data with messages, we have some customers who have used macros to do that formatting/transformation/copy.  However, the messages still go on the sheet with the data you are uploading.

    If this doesn't help, please consider submitting an improvement idea on the Ideas portal here: https://ideas.precisely.com/?project=ST.  .

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------