Gantt View/Schedule W/out Weekends

Hello, I am making a construction schedule for one of our projects and I cannot figure out how to disable the weekends. The 'Duration' column is the one that gets manipulated. I want it in a way that both 'Start' and 'End' columns update based on the inputted duration.

Screenshot 2025-05-16 142254.png

and 'End' columns get automatically updated based on the inputted duration.

Tags:

Best Answer

  • melissalk
    melissalk โœญโœญโœญโœญ
    edited 05/16/25 Answer โœ“

    Hello! Have you updated your working days schedule under Project Settings? If you right click on any of the top column headers (Building Phase, Start, End,โ€ฆ) and select Edit Project Settings you'll get a pop up where you can set up your work days, turn off weekends, and also input your holidays:

    image.png

    I hope this helps!

    -Melissa

Answers

  • melissalk
    melissalk โœญโœญโœญโœญ
    edited 05/16/25 Answer โœ“

    Hello! Have you updated your working days schedule under Project Settings? If you right click on any of the top column headers (Building Phase, Start, End,โ€ฆ) and select Edit Project Settings you'll get a pop up where you can set up your work days, turn off weekends, and also input your holidays:

    image.png

    I hope this helps!

    -Melissa

  • Ray987
    Ray987 โœญ
    edited 05/16/25

    Got it, thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!