-
Project Tracking and Roll up
I'm working on this and is there anyway for the reports i create to not make changes to the existing working smartsheet? I'm afraid I'm going to mess something up on the working smartsheet. As in, if I move columns will it also move on my working smartsheet? How would I change or identify the primary column in a report?…
-
How to print selected columns
I'm new to Smartsheet and I have inherited some sheets from my predecessor. I'd like to print a Gantt chart and a grid. My question is, how do I specify which columns will be printed? When I print the grid it prints all columns I can see on the screen but I want to exclude some. When I print the Gantt chart it only prints…
-
Merged: Develop the ability to add CONSTRAINT TYPES to project schedules
This discussion has been merged.
-
How can Smartsheet be utilized to create a searchable resource repository?
Hi everyone, My team and I are exploring a Smartsheet solution for a searchable resource repository. We currently have a variety of resources available to our managers to help them coach their associates, including job aids, videos, simulations, etc. These resources are housed in different locations. We would like to…
-
Backward timeline?
Hello! I'm looking for help to create a simple sheet that starts with a launch date, and assigns tasks dates using task durations. I'd like to use columns like tasks, start date, end date, duration and predecessors. Is there an extra column with a formula that will be needed?
-
How to calculate parent-level values in multiple columns (not just % Completed)?
Hi, In my project sheet, only the % Completed column rolls up automatically using parent/child logic. That works fine. But I want to do something similar in other columns, like: Variance from Baseline (%) Weighted Variance Planned Progress (%) These are all calculated row by row, but I want to show an accurate value at the…
-
Best Way to Facilitate Task Hand-Off to Different Assignees
I've been trying to build out a solid "template" of sorts to help manage numerous tasks/subtasks for similar but different projects. Each row contains a parent task or a child task (subtask). Many of these tasks change hands throughout the process of the project as it evolves toward completion. As one example, Assignee A…
-
Different way to track health
I have a project without a set end date and am being monitored on if I am getting it closer to completion by the % complete field, how can I make a formula that tracks health based on that forward progression so that if my % complete goes up it stays green but if it stays the same for three days it goes to yellow and if it…
-
PMO Template-- Archiving Projects
I have begun setting up/ using the PMO template. I am wondering if there is a way to archive old, completed projects so my project-level folder stays organized but the data is still available. Thanks
-
Way to calculate parent row % Complete in other columns (like % Complete) for SPI.
We have a Planned Value column that is based on Start and End dates and a SPI column that is based on Planned Value and % Complete. Our Planned Value column is used to show what the task % Complete SHOULD be for the project where the % Complete is what the ACTUAL % Complete for the project is. The SPI uses %…