Making a Gantt View with only working days (Mon to Fri, exclude public holiday)

Is there a way to remove weekend and public holidays from Gantt chart?

I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can I have the duration formula only calculate # of working days?

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    edited 09/25/24

    Duration is working days. If you have a 2 day duration task that starts on a Friday then you'll see that it ends on the Monday (4 days in time) but still shows 2d for the duration (2 working days). You cannot change this calculation if you have dependencies turned on for the sheet in the project settings.

    You can, however, do your own calculations in other columns if you want more control over the formula. For example, if you add a column and put =[Finish]@row-[Start]@row then you'll notice the same Friday to Monday task shows 4 as a value (in days), therefore disregarding the nonworking time defined on the sheet that the Duration column is taking into account. You can also use NETWORKDAY and NETWORKDAYS to run calculations that DO include the nonworking days.

    You can set which days are working vs not working in the setting for the sheet while in Gantt View.

    All that said, you cannot "turn off" days from showing on the gantt chart itself (ie you cannot hide Sat and Sun "columns" on the Gantt). And if you have nonworking days defined on the sheet, you cannot prevent Smartsheet from scheduling around those days (extending the Finish date of a task to provide enough working days based on the duration). That's intentional - kindof the point really.

    You may find it more useful to leverage the Timeline view which has a little more control over zoom levels and doesn't present nonworking days visually (although the data is still taking those into account)

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN