-
PMO Template Project Plan not displaying correct End Date at top row
Happy August! This project plan was created using the Smartsheet PMO Template, which I have done many times before. How can I get the End Date in the first row to show the correct date (8/31/23), instead of 8/17/24? It's not rolling up. Thanks in advance for your help.
-
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.
-
How do I set up a workflow to notify someone if a predecessor task has been completed?
-
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,…
