Smartsheet Template

Options

I have created a sheet template from an existing sheet. The existing sheet, prior to saving as a template, had many rows of data The template copies all the data from the original sheet. I only want the sheet layout and formulas. Is there a quick way to remove cell data on the template sheet.


I guess better approach is to create a sheet and save as a template before inputting data??? Right?


What about creating a template from an existing sheet with data in cells. Any best practice for this?

Tags:

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @theuser

    I hope you're well and safe!

    You can select all rows and delete them and reload the sheet. There will only be empty rows included, ad then you can save that as a template or save the original one as new again and deselect options in the Data & Formatting Options section.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    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.