-
Cell Linking not following to sheet "Saved As New" in Marketing Campaign Template Set
Hi there, I'm digging in to the Marketing Campaign Template Set and am hitting a wall. When I'm saving a campaign as new, the cell linking in the sheet "3. Campaign Plan" is not showing up. Does anyone have experience with this template set that they could help troubleshoot why this is happening? TIA! Here's the original…
-
Preserve specific email address in a Workflow rule in a Template
Allow for a Workflow saved in a Template to preserve any rule configured to be sent to a specific email address (as opposed to a Contact list column) when the Template is used to create a new Sheet. This way, you won't have to re-enter the specific email address in the workflow each time the Template is used to create a…
-
Blueprint for Different Project Plans
We have different sized projects (small, medium, large) and each one will have a different project plan template. We currently have an intake sheet setup with Blueprint so that once a project is approved the standard template is used. However, we would like to use another column in our intake sheet that shows which size…
-
Has anyone turned into the Employee Onboarding template into a rollup format?
Hi all, I'm working on a project for Employee Onboarding. After discussing with stakeholders, I think the Employee Onboarding template (Setup: New Employee Onboarding - Smartsheet.com) is a great start, however it doesn't meet some of the needs we are looking to cover. I'm reaching out to the community to see if anyone has…
-
Pulling data dynamically from standard project folders
We found a template for multiple projects that uses a standard folder setup to keep Reports, Project Plan and Dashboards for each project within its own project folder... allowing us to have the separate lists of tasks and RFI's, rollups organized for each project rather than a forever-growing list of entries from old…
-
PMO Template
Dear All, I like to understand how I can re-create the header row that I find in the Project Intake Sheet in the PMO Template. Can someone please advise? If I set up teh column with a function (e.g. Auto number) it is impossible to enter the word "Project ID" in teh first line as shown in teh image below. How does that…
-
Data cannot be charted, unable to read source data.
I am using a template from Smartsheet (Project Tracking and Rollup). When I attempt to link the sheet to my chart widget, I get the "unable to display chart" notice. The chart should show percentage complete, but it doesn't. I will add photos of what it should look like, the notice, and the sheet that the chart is pulling…
-
Concatenate formula with IFBLANK
We are trying to move some of our more complex templates into Smartsheet but we're having trouble converting the concatenate with blank formulas from excel into smartsheet. For example we have this formula in excel =IF(M2="","New",M2), and all I can seem to get to in Smartsheet is =IF(ISBLANK([If nothing is indicated,…
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
-
Pivot App - Include Pivot Charts in Template
We have a Workspace template that is duplicated (in control center) for each project but the pivots aren't included in that template and have to be reconfigured each time. This is unrealistic for the volume of projects we need created. Same applies for other premium app configurations, too.
