Hi everyone
I have a template saved in a workspace but can't see how I can edit this - can anyone help please?
Thanks!
DW
Hi DW,
Unfortunately, you can't edit a template. You have to either edit the original sheet (if you still have it) or make a new sheet of the template and edit that and then replace the old template with the new.
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
Thank you so much!
Happy to help!
Smartsheet also has a Control Center add-on. It costs a little extra, but allows you to update templates as well as any old sheets created from the template across the board.
How does this impact the sheets that's already created using the template? My understanding is that it'll push through the changes, however, if it's a project plan and there are changes specifically to that project, would the change in template over-ride?
So I recently downloaded the Project Template: This is exactly what I want with some changes, however it seems there some items "locked out" or something. The formula in the "Project metadata" sheet can't be converted, (formula syntax error) and if I overwrite the template's "project name" I get no match. In trying to check the reference I get
So, am I expected to use this template as a model and generate my own sheets/dashboards/reports etc.? I'm the owner of the workspace the template resides in. I'm replying here as it's a similar template question.
Thanks
Hi, I hope you're well and safe! Are you still having issues? I hope that helps! Be safe, and have a fantastic day! Best,Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD ✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Andrée,
Safe and well, just hot, lol (Arizona). I continued to play around with the template, I even deleted everything and downloaded it again, then followed the directions exactly. Two things of note: One, if I change anything in the Project Intake Sheet, it does not reflect in the linked Project Metadata sheet.
Project Intake Sheet:
Project Meta Sheet (even after repasting the Row ID)
Second, if I use the Intake form, all seems well, it creates a new project and row ID just fine.
However pasting that row ID into the Project Metadata sheet, gives me this:
Pasting it into the line below doesn't work either, because the following rows have no formulas.
OK I thought, make the formula (below, an index match) a column formula.
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row , {Project ID}, 0), MATCH([Project Name]$1, {Portfolio Summary Header Row}, 0))
But that gives me this:
Weird, but sure, I mean it doesn't seem to be working does it? What about the references? It's a type of Index/Match I haven't used, and further I can't seem to find the sheets, so assuming they are reference names, not sheet names, I try to look at the referenced sheets, by clicking on "edit reference" links in the formula.
That results in this error:
So am I just missing something in the instructions? Is there more I have to build out to make this work?
I don't mean to hijack someone else's topic, but it seems editing a template is where I'm finding myself. I fully admit that working with this set of sheets will be stretching my abilities with SmartSheet coding (but we always want to stretch right?) but this is exactly what I need for a new functional rollout. I mean it couldn't be more prefect.
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…
I need to be able to pull data manually from the source sheet into a report to send to another person for approval. I do not want to give the person approving access to view other sensitive information on the source sheet. Is this possible?
hello, How can I set our account to reflect real time and dates. for example, when viewing the cell history, It usually shows the day before. The correct time stamp for this edit should be 9/3/25 5:50pm. Any way to change this to our correct time zone? We are in Guam.