-
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,…
-
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…
-
Formula Help
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…
-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…