-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
Merged: parent timelines when dependencies are enabled gantt Bar formatting
This discussion has been merged.
-
Folder (Highlight) Colors within Workspace
I have access to multiple folders within my workspace, like everyone does. I would like the ability to highlight folders. And my highlighting would be exclusive to my account. Others that have access to the same folders would not see my highlighting. The main folder names (mostly created by others), are so similar. I often…
-
Survey- how do you track projects over multiple years?
Hello Community, I am trying to track projects over multiple years, but each project varies in length. My concerns are hitting the max number of columns and not having to do a bunch of manual set up at the end of the year. Has anyone else had this issue? How did you solve it? Thanks, Ashley
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
I need to calculate % Complete
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
-
Pay Application Sheet
I'm a facilities project manager at an educational institution. We have begun using smartsheet for our project management tracking. I'm wondering if anyone has developed a pay application sheet they use in their applications. I think I could probably build one that will work but no need to reinvent the wheel if one already…
-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
