-
Elapsed Days Counter - How?
Hi everyone, I'm needing to report on elapsed days for a few tasks. Anyone know how to do this? Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet. Any help is greatly…
-
Flexible Duration value when calculating scheduling dates
It would be useful for the Duration to be dynamic (e.g. linking cell to a cell in another sheet or to contain a formulae) as part of the scheduling calculation to automatically derive the start/end dates for tasks in a Gantt Chart. It is quite common in a construction project for the Duration element of a task to be based…
-
Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
-
Repeating columns on Gantt chart on all sheets
I don't see where this has been brought up in the last 12 months, but a simple but helpful feature for Gantt charts would be to be able to select columns on the left that would repeat on each page of a multipage Gantt chart regardless of the scale used for the chart. For example a 12 month schedule could be broken into…
-
Start/Finish Date Updates based on Status - Gantt Charts
I have a Gantt Chart that my company uses to track a multi-step process. In this process, Step 2 cannot begin until Step 1 is completed, Step 3 cannot begin until Step 2 is complete, etc.. Each step normally takes 2 weeks (and this is what we have in the Duration column), but due to the number of moving pieces it can…
-
Not all "Actual" bar show in gantt chart
Hi, Some of the tasks/sub-activities in my gantt chart do not show the "actual" bar even there is a reported progress (e.g. below activity with 25% progress). I'd appreciate any advise. @Andrée Starå @Genevieve P. perhaps you can assist? Thanks IPC
-
Display timelines for customised fiscal year
Dear Smartsheet community If you work in a company with fiscal year not starting in January, you might find this improvement useful: change FY year only is displayed from the last month in a fiscal year. Because this might be confusing, I propose to show FY split year, e.g. FY 22/23 instead of FY 2023. Example: if the…
-
Column Formulas not appearing on Gantt Chart
Hi everyone, I have a column consisting of "expiration dates" and another set of dates called "extension dates" if an extension has been made. I have put the formula "=IF([Extension Approval Status]@row = "ENABLED", [Extension Date]@row)" in the "expiration date" column, If an extension has been made and has been approved,…
-
Manpower Loading Schedule
I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. For example I would like to have a list of dates and then show how many crew members working on those…
-
View multiple (start and end) dates in Gantt view at the same time
Hello everyone, so I am working on a transformation project that has many iterations/phases with a start date and an end date, so I have 5 phases with a start date and an end date, is it possible to view those 5 phases at the same time in Gantt view, like being separated and not as a same block ? Which means there are 10…