-
Parent Row Color Settings: Task Bar in Gantt View
Is it possible to add the ability to change the parent row color settings, especially as relates to task bar color in gantt view?
-
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…
-
Gantt view - not able to scroll to left and right
Hi all, I like the gantt view in SS. However, I am not able to move left and right. Any idea what's happening?
-
Workday function
I want to calculate the working days from the start date. However, we have Sat as a working day which I have configured in the Gantt setting. (So we have 6 working days). When I use the formula WORKDAY ([Start Date],38), from 3-Mar-2024, I get the output as 16-Apr-2024 - which is correct. 3-Mar-2024 being Sunday. When I…
-
Identifying successors of successors (and so on...)
Current status: I've successfully generated a "Successors" column, listing direct successors of each row, using the following formula: =JOIN(SUCCESSORS([Task Name]@row), ",") Current roadblock: My "successors" column only shows direct successors. I'm looking to create a column that lists ALL successors, all the way up the…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
Gant Chart - How can we track the planned versus actual LAG days?
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
-
Provisioned Project Plan Changing to Gantt View from Grid View
We have a project plan that we spin up using the multi-tier functionality in Control Center (the plan is our child project) and each time it is provisioned the default view is Gantt. BUT in the template it is in Grid view (which is what we prefer). How can I fix this?
-
Why does Gantt change to quarters instead of months when printing PDF?
Hi, I have my projects settings to show months, not quarters. I am admin and owner. I am currently in a free trial of a business account. My gantt chart shows years and then months, except when I print to PDF. It automatically changes to quarters, I can't figure out why it would do this.
-
Gantt Charts Hour Minute
Currently, the desktop app supports Down to the Day for the Gantt view. Is there any way to have projects in hours on the desktop app instead? Finding another piece of software to do this common practice of a project that lasts a couple of days but has many moving parts and dependencies is frustrating. We have run into…
