Sheet scalability

Ian

I have a sheet that I built for year-end performance reviews.

 

The sheet is designed for one person.

 

My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list.

 

Any ideas?

 

Thanks

Ian

Sarah Steele

You may want to consider turning your sheet into a form.  Seeing an example would be helpful.  

 

I have seen a Zapier (I believe) that generates a new sheet based on a trigger as well.  

 

 

JamesR

Ian,

 

I am with Sarah, change the sheet to be for multiple people, do not share but send then the web form.  If you want Conditional branching create a Google form which allows it anf it will create the smartsheet.

Use oogle docs to mail merge reports to document or PDF

 

Much better that 1 sheet per person.

 

James

Ian

Each person has different goals on their performance reviews, so a webform wouldn't work

Travis

This is definitely something Zapier and Azuqua can do! They can create sheets based off a trigger (such as adding data to a row). Once set up, if you add 50 names to 50 rows, 50 sheets could be created with the respective name included in each new sheet.

 

zapier.com

 

azuqua.com

J. Craig Williams

For my team, I created one sheet for me and the build a Report for each team member to view.

 

I would Save-New to keep the completed reviews and cleanup the sheet for the next period.

 

But I only had 12 reports.

 

Craig