Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Editing a template

Sylvie Serplet
Sylvie Serplet ✭
edited 12/09/19 in Archived 2015 Posts

How can I edit a template to delete a row?

· Share on FacebookShare on Twitter
«13

Comments

  • Ted Cochran
    Ted Cochran ✭

    Templates can't be changed, but you can do this...

     

    Rename the template.  Create a sheet from the template and make your change.  Delete the template.  Save the Sheet as a template with the name of the original template. 

     

    HTH,


    Ted

    · Share on FacebookShare on Twitter
  • Sylvie Serplet
    Sylvie Serplet ✭
    edited 05/03/15

    Thank you Ted for your prompt response. Smile

    · Share on FacebookShare on Twitter
  • System
    System Employee Admin
    edited 12/30/15

    @Ted Cochran

    This method is a bit convoluted. Are you going to make templates editable?

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Hi Shawn, there are not any near term plans to make templates editable, but I will add your vote for this. Right now the method what Ted suggested:

     

    -Create a new sheet from the template

    -Make your change

    -Save the new sheet as a template

    · Share on FacebookShare on Twitter
  • Valerie Marquez
    Valerie Marquez ✭

    Please add my vote as well to have templates editable. This would make it much easier and more user friendly. 

    · Share on FacebookShare on Twitter
  • Allen
    Allen ✭

    Can't edit a template? What the what? That seems pretty basic...you got my vote.

    · Share on FacebookShare on Twitter
  • Eugene Coffie
    Eugene Coffie ✭

    Please add my vote to edit templates as well.

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Thanks everyone - your votes are added.

     

    You might consider using a sheet as a template - rather than a template.

     

    Create the sheet you want to use as the template and share it out to whoever needs to use it, as a viewer. When you or anyone else needs to use it, open the sheet and save a copy.

     

    This works just like a "template" but you can share it and make changes to it. 

    · Share on FacebookShare on Twitter
  • Robert W. Sansom
    Robert W. Sansom ✭

    +1 for editable templates, as they serve little purpose if they can't be edited and if sheets created from a template cannot auto-update when the template is updated.

    Today I do what Travis talked about - I have a master sheet titled 'aaa (template)' that I "Save as new" when i need to create a new sheet. (99% of my sheets have the same format and layout - so having a template sheet is absolutely necessary)

    My biggest frustration however is when I go back and edit the structure of my "aaa (template)" sheet, e.g., add a new column, add a new item to a summary section,  I can't have the change applied across the other sheets, and I have to go in and edit each sheet. Very time consuming.

    I want a template that allows me to define the columns and their layout/types and specific rows and cells that persist across sheets, and which cells are editable vs. not editable (e.g., labels). And if I edit the template, any child sheet will automatcally receive the changes without affecting any of the sheet's editable cells.

     

    This feature would be an immediate win!

     

    I would also expect the ability to break a sheet from its parent template if I wanted.

    · Share on FacebookShare on Twitter
  • Josh Garcia
    Josh Garcia ✭
    edited 01/19/17

    Please add my vote for making templates editable.

    · Share on FacebookShare on Twitter
  • Jose Alvarez
    Jose Alvarez ✭✭

    +100!  They MUST be editable!  I need a template for a course creation project (almost 100 courses), and imagine what I would need to do if the process changes?  I would need to manually update 100 sheets!  Nooooooooooooooooooooooooooooooooooooooooooooooo

    · Share on FacebookShare on Twitter
  • Jim Nubiola
    Jim Nubiola ✭

    kudos on this

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Everyone—

     

    I've got all of your votes down for a way to edit templates (without having to create a new template) on our enhancement request list for further review by our Product team.

     

    We appreciate your input!

    · Share on FacebookShare on Twitter
  • Jose Alvarez
    Jose Alvarez ✭✭
    edited 02/15/17

    Awesome news!  Also, please add a an alert message so that when a template is updated, the systems asks: "would you like to apply these changes to all sheets created from this template previously"...or something like that.  You know what I mean.  

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 02/15/17

    Hi Jose,

     

    I've added your vote for a way to make batch changes to sheets created from the template as well.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories