Share sheet as a copy - Consolidation

Hello everyone,

Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators.

The idea is :

I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually
I want to keep track of all the status of certain indicators for each collaborators
I then would like to consolidate the data into my main spreadsheet (basically a sum of values)

I did find success using a workspace and manually create a new sheet from a template for my collaborators, then consolidate the data thanks to a Report.

However, if I change my template, I have no way to automate the create new / share sheets part of the process. Any idea on this?

Thank you and please let me know if this is not clear (French here!).

BR,

Paul BUREAU

Find more posts tagged with

Workspaces

Templates

Publish

IT & Operations

Product Development

Project Management

Groups and Group Management

Importing and Exporting

Comments

Jim Hook

Paul, I'm not 100% sure what data the others have to enter but it might work better to use webforms that the users fill out and submit which would cause their data to automatically come into your combined sheet where you can process the data. You would still need to edit the webform to accommodate more or less data if your format changes but one webform could be shared with all users. There is no way that Smartsheet can automatically create new sheets for your other users when tings change.

Paul Bureau

Jim,

thank your for your answer. However, for a complex and large spreadsheet I doubt a web form could fit my needs.

A more global question would be : is there a way to help me duplicate / share a sheet massively ?

Thanks again,

Paul.

Sign in to join the conversation!

Quick Links

Trending discussions

Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
Cannot move items
I want to move a sheet on my workspace to another folder but I am not getting the option to do so. I am the owner of the workspace, the sheet and the folder.