Why would you save a sheet as a template vs saving as a new sheet?
I have a master sheet that I plan to replicate multiple times retaining all configuration I have done ie workflows, attachments, predecessors. It appears that saving as a template and saving as a new sheet would retain all of those features. So what is the benefit of saving as a template vs saving as a new sheet (and vice versa), is there something obvious I am missing? Thx.
Answers
-
The biggest thing would be that you can't start keying into the sheet and unintentionally save over something by mistake before saving as new with a template.
-
Hi Leslie,
Templates are perfect if you need a new sheet often for a specific task or if someone else, and it should be as simple as possible.
It's simpler to start and save from a template.
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Piggy backing on this, is the new sheet (from a template) able to feed back into a different sheet??
Thanks!
-
Unfortunately, it is not possible with formulas, but maybe through a copy row automation or similar.
Would that work? What is the process?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå I have a similar question. I created a template from an already populated sheet. Meaning information in it already Plus formulas/automations etc.
I am trying to only create a template with the formulas and automations BUT all the information in it is transferring to the template as well.
Is there an option to create the template with only formulas/automations and row settings?
Thanks
-
@Jose Robles Have you checked the options at the bottom of the "Save as template" box?
-
Hello @Paul Newcome that worked, thank you!
-
@Jose Robles Happy to help. 👍️
-
I saw that Paul had answered already, and my answer would be the same!
Let me know if I can help with anything else!
Best,
Andrée
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives