-
Reference Formulas in Templates
Hello, I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this? Thanks in…
-
Creating and Saving Template Sets
Hey Is there a way that I can save a folder, that I created, containing sub-folders, which contain sheets, reports and dashboards as a template set?
-
Importing Excel Data into a template
I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but since the limit is 500 rows at a time, it takes time. I cannot seem to find a way to…
-
Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now. The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets. Question: Do I have to manually update the…
-
How to set up and automate a template for this report chart in the dashboard?
Hi guys, do you know how to set up the following report chart in my dashboard? I have seen this kind of report chart in one of the Smartsheet webinars. My requirements to this report chart would be : Every time I set up a new project plan, every person in my "Assigned to" column should be automatically involved in this…
-
Template set with URL Links not working
I have a project plan with 3 supporting worksheets. I want to launch the supporting worksheet FORM within my project plan. So, I copied the supporting sheets FORM URL into the attachment cell on the appropriate row for each corresponding support sheet. So far, so good. Then, I did a "Save As" using the option to have all…
-
Dashboard Form Widget - Product Enhancement
I am sure that I am not the only one that has copied a dashboard with needing to go back and edit the "web content" widget which contains a Smartsheet form. It seems like this is one of the few things that does not update when you copy a folder containing your sheet, form, report, and dashboard. Thus, if you have updated…
-
Annual Calendar Template by Day multi activities
Hi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?
-
Facility Bookings
Hi all. We manage many government/public venues and facilities (sports arena, stadium, parks etc) for which we facilitate bookings. At present, bookings are logged using outlook only viewed by one person. We'd like to begin using smartsheets for bookings so clients (the public) can view available (or unavailable) dates,…
-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
