-
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?
-
Merged: parent timelines when dependencies are enabled gantt Bar formatting
This discussion has been merged.
-
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…
-
Gantt Chart - Percentage Complete
Hi, I'm new in Smartsheet coming from the MS Project world. I'm trying to include the % of task completion in a gantt chart. I'm filling in the % complete column but nothing appears on the gannt chart (contrary to what is described in…
-
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?
