SteveE
SteveE
Reactions
Discussions
- I am using the formula below to insert a row into a Scorecard sheet to show the {AP Project ID} from the Approved Projects sheet when the {AP Release Cycle} = 2024 and the {AP Project Status} = “Compl…
- I created a report to show baseline variance metrics for all projects in our portfolio. In the report, I tried to summarize the project variance field, and you can see the result below. I do not get t…
- New user here. I downloaded the PMO Office Template Set and added a "Business Area" column to the Project Intake Sheet. I want to link that column to the Project Metadata Sheet. My goal is that for ea…
- I thought I would post my issue here since the SS community has been so great at helping solve my other SmartSheet dilemmas! For each project that the PMO oversees, we have a sheet with a single row o…
- Our year is broken into accounting periods which differ from calendar year/month. For example, period 1 starts on 12/30/23 and ends on 1/26/24. In my project plan, I look at the start and end dates of…
- I have a project plan that currently uses 2 columns for task management: Assigned To: resource that is the owner of the task Additional Resources: resource(s) that will also be working on the task Rat…
- Our project plan has a resource field that can have up to 5 people/contacts assigned to a task. I am looking for a way to scan the field and pars/separate the resources into individual columns (exampl…
- I have a sheet with a resource count than can be blank or contain from 1- 5. For each resource count there is a corresponding work effort in the next column, separated by a comma (see table below). I …
- Overview: I have a project plan (below) with a column for the user to enter remaining work effort/hours to complete a task. We also have milestones (checked tasks Main Task A, B and C in example). It …
- I have a sheet where I am counting the number of variance root causes if the milestone field is checked (first column). Variance root cause is a multi select drop down. In the above example, the count…
