-
How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks. This is only a problem in breaking the links going from the…
-
Overall Average Percent Compete
Hi All, I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0,…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
Template question
Hello. Is there a template or template set for change management within Smartsheet that currently exists? Thank you!
-
Use Predecessors for a Shared Start Date and Extended End Date
I am working on a marketing project plan template, and some of our campaigns spend multiple days in market. Tracking the performance of these projects happens for the duration of the project plus the duration of an attribution window. Example: An email campaign launches on 4/1 and runs through 4/7, and any email leads…
-
Using Formulas for Start Date/End Date in Project
Hi Smartsheet community, I am working on creating an automated Gantt chart based off another sheet that I am using to run an Agile project. It is not going well. My 'source' sheet is a grid that shows each of our deliverables and iterations. I have used an index-match formula to bring that data into the Gantt chart so the…
-
Sharing Dynamic View & Dashboard with Non Users requiring sign up
Is there a way to share Dynamic View and Dashboard access to non-users without requiring them to sign up for smartsheet?
-
Linking directly to files from a dashboard?
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Saving as images wont work either, as we have 10+ files to link to, and want to organize…
-
Formula to Roll Up Task Status
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Parent shows as Not Started if: All children are either Cancelled or Not Started. Parent shows as In Progress if: Even one child…
