-
Gantt View Earliest Start Date
How do I get a row on a Gantt chart to show the earliest date from amongst a set of predecessors? I have a gantt chart where I want one row to display a 0-duration task with the earliest start date from amongst five predecessors. I've entered them as start-to-start predecessors, so in theory it should start when 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,…
-
Allow formatting of the Today Line in Gantt Charts
There is no way to change the formatting of the line to either make it more visible or to disable it/make it less visible. You should be able to change the today line.
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
-
Display Multiple Dates as Milestone in Gannt View / Timeline View in Smartsheet Reports
Hi, I have a query regarding the display of multiple dates from different Columns (5-6 Columns) from a report in Gannt View / Timeline Row within a row. Basically, Gannt of Gannts showing multiple projects in each row showing multiple Dates i.e. Gate Review dates in same row.
-
Gantt Chart View in Reports
Please help! I understand that we can't customize the gantt chart bars anymore if it is a parent row but why am I getting random colors on the bar view in my report? I would prefer it remain grey. The first picture is the Smartsheet and the second one is the report pulling from the sheet.
-
Compiling a multi-department calendar/timeline
This may seem super basic, but I work in tandem with 4 different teams and need to construct a calendar/timeline for all of these separate departments. What is the easiest way to gather the information? Some teams use smartsheet, some use excel, but none have the same format and none really "talk" with each other - hence…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Gantt View has come to WorkApps!
Hi Community, We have to admit, not having Gantt view in WorkApps kind of limited the scope of its project management functionality. Fortunately, we’ve gone ahead and taken care of that. Our latest release enables WorkApps to support Gantt view in the sheets experience! App users can now build pages using this view and end…
-
Lost all tasks in Gantt view
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?