Exclude weekends from a schedule

edited 12/09/19 in Smartsheet Basics

I am using this for a project schedule and wanting to exclude weekends permanently.

I am using the start date and duration fields for this schedule but need to exclude weekends.

For example if a job starts on Wednesday and is a 5 day duration i need this to show as complete on Tuesday (as our trades don't work Sat/Sun)




  • Ofir Marco


    Here is the solution:

    1. Right-click on the duration column and click on "Edit column properties".
    2. Click "Project Settings"
    3. On the project settings screen click on "Edit" below the 'Working days' section.
    4. Set your working days.

    *See screen shots below

    Column Properties.png

    Project settings link.png

    Edit - project settings.png

    working days.png