-
How can I add a widget to show overall project health, pulling data from a Master Timeline?
Hello, I am trying to add a widget to my dashboard to show the overall Health of a project. I already have a health column in the sheet I will be referencing, and I have added a chart to the dashboard showing the individual tasks and their Health, but I want to add a widget (please see below what I am looking for) based on…
-
Include predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
Merged: Add Column Type 'Time' in 12 & 24 hour format please
This discussion has been merged.
-
HELP - Creating dependencies but using start-date instead of lag
I am building a plan with my stakeholders, we have a number of sprint-based tasks that have dependencies. It is very painful to constantly use the 'lag' function for all of these. How can I:1. Link activities using dependencies so they can be visualised in the plan. 2. Allow me to put in a start-date for the successor…
-
google drive integration storage best practices
We are an enterprise higher ed group familiar with Smartsheet, but new to using the Google Drive integration. We are (hopefully) transitioning our documentation processes away from clunky word docs into the more automated Google Docs direct from our project register as work requests come through. I've gone through the…
-
Interdependencies Across Sheets: Are they possible to track?
I was discussing the Dependencies tool in Smartsheet with my manager and how it could be utilized to track the Critical Path. Also how we can use Baseline to track any major changes to the project timeline. While discussing this, he asked if there was a way track interdependencies across different sheets? For example, if…
-
Meeting Management - Implementation of Template Set
Hello All, Has anyone implemented the Meeting Management template set who would be willing to share what works and what could be improved? We are looking at moving our minutes into Smartsheet (obviously), and I would like to understand a bit more. The "Getting Started Guide" for the Meeting Management template set is a bit…
-
Auto reference a file added to a folder that a Report is pulling from
I need help finding a way for my reports to automatically pickup new files. I have numerous reports that need to reference everyfile that is in a given folder. When these are first setup, it is very easy to select the folder for the "where" portion and it grabs every file within those folders. However, it doesn't appear…
-
Finding a value from one sheet on another sheet and transferring cell info onto both
I need help figuring out a formula that will cross reference between two sheets. I have one sheet that stores our open orders and another that tracks our orders undergoing quality assurance. What I need is a formula that takes the order number from the open order sheet and searches for it on the quality assurance sheet,…