Enter duration as "Net Days" but still count work days without Sat/Sun.

JustJoe

 Under project settings I want to make Saturday and Sunday as working days so "Hard" products would follow a timeline that includes weekends. A task starting on October 1st with a duration of 31 days would end on Oct 31st.

 I also want to count the number of weekdays (exclude Sat/Sun) between two dates so I calculate total labor cost. A task starting on Oct 1st and ending on Oct 31st would have a duration of 23 days.

 Is there a easy way to accomplish both of these items on the same sheet? Is there a way to use multiple calendars --> similar to Projects?

J. Craig Williams

The easiest way may be to use the 'elapsed' function of durations.

Search this article for 'elapsed' and see if that helps.

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors

If not, there are more complicated ways to likely get your solution.

Craig