-
How can I calculate the correct task count on project plan?
Hi, Community. I need ideas on accurately computing the task count. My project plan has child tasks but counts the parent tasks. Thank you😀
-
Does Smartsheet Support "Schedule Performance Index" (SPI)?
I've seen some past posts where users tried to create their own columns for this, but they seemed to have errors in the way the calculations were done. What is the latest solution from smartsheet (or recommendation from end-users) to have a calculation that works correctly for SPI? It should be SPI = Earned Value/Planned…
-
Resource Management to assess Duration from linked Smartsheet sheet
Hello, Are there any plans to incorporate the Duration information into the dataflow between Smartsheet and Resource Management (RM)? Currently 5 columns are synched between the two platform: Task name, Assigned to, Start Date, End Date, Allocation% Now as you see, Duration info is not at all accounted for when RM…
-
Is there a way to show those who will be out on PTO and what deliverables overlap with those dates?
My vision is to show calendar/widget of individuals that are out of the office/pto and which deliverables overlay with that time off.
-
Manpower Projection Formula
I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have durations that overlap with other tasks. I want a separate manpower projection sheet that tells me each day what the total…
-
Unexpected Two-Day Shift in Project Timeline When Copying from Microsoft Project to Smartsheet
I've encountered an issue where I'm copying all data from a Microsoft Project file into a Smartsheet project. Despite matching the duration, date format, and predecessors exactly, Smartsheet somehow adds two days to the project timeline, causing discrepancies. Does anyone have any insights into what might be causing this?…
-
Project Plan - adding a new task with the subtasks.
Hello :) Can you please help me understand how to add a new task to a Project Plan Sheet? I need a new task category with the subtasks attached to it. An example is Planning—Project Kickoff, Activity 1, etc. Thank you in advance!
-
Automatically have a project name <<project>> appear on each row
I would like to ensure that when an additional row is added to a project plan, the Project Name column is automatically populated with the project name. This name is pulled from the Control Center and is located under the summary section of the sheet. While I am aware that I can manually add the «project» to every row,…
-
Best Way to Link Dates between sheets?
We want to pull high-level dates from a project plan to add details on another sheet so it's easier to discuss. For example, we may have 'Topic Meetings' as a single line-item on the overall Project Plan, but on a meetings sheet we would have 'HR', 'Finance', 'Tech', etc. We turned off dependencies on the meetings sheet…
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…