Sign in to join the conversation:
Hi Guys
We have a sheet with a dashboard that we would like to use as a template
The sheet can be saved as a template but what about the dashboard?
We do not want to have to keep on reentering the widgets....
Thanks
I often "save as new" an entire folder with dashboard and supporting widgets including reports. It then typically takes me a few minutes to customize the new dashboard, reports so that they import the correct records to support the new dashboard.
When you Save as New with a folder, there is the option to have "Any reports, dashboards, sheet hyperlinks and cell links will refer to:" and select "Newly created sheets".
I use this A LOT. I built out an entire folder complete with a Project Plan, Dashboard, Metrics sheets, Reports, etc.
My entire department uses this and we have had no issues at all with the process. The only things that need changed are the finer details such as the client's name and whatnot in the Charter and the Client's Logo in the Dashboard. Otherwise all of the widgets pull from the new sheets and reports and the proper cell links and cross sheet references in formulas all carry over to the new sheets.
Even the new reports pull from the new project plan. The only thing I need to change there is the name of the report itself since I include the client's name in the report title.
To add to the above!
I've built solutions for clients were we save as new for Workspaces instead or together with folders.
It works great!
Best,
Andrée
I have done that a few times as well, but forgot about it. I do love the Save as New feature while linking to all of the new sheets.
Thank you all! This helps
Great!
I'm always happy to help!
Happy to help!
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
