One sheet populating a master sheet.

Is it possible for one sheet be filled in with information then once saved, it will auto populate the same information onto another sheet (the master sheet)?


For example, master sheet is called "Fruits". 10 people are assigned to a different fruit. One person has their own smartsheet called "Apples" another person has a sheet called "Grapes". When they input information on their own sheets, those information will go to the "Fruits" master sheet.

Best Answers

  • Mike TV
    Mike TV ✭✭✭✭✭
    Answer ✓

    @SmartsheetRookie

    Yes, just use an automation set "when new row is added" with an Action of Copy Row to the Fruits sheet. You'll need to set up the automation on each of the apples, grapes, etc sheets to feed to the master sheet.

  • Mike TV
    Mike TV ✭✭✭✭✭
    Answer ✓

    @SmartsheetRookie

    Make sure the master sheet is in a workspace and not just in your sheets list. If it's not your sheet, you may need to be shared to the workspace.

Answers