Multiple Duration Columns

Hello.

I'm a new Smartsheet user. I used the "built-in" duration column to calculate the number of workdays between the Planned Start Date and Planned End Date. I also need to calculate the number of workdays between Actual Start Date and Actual End Date. What is the correct formula? (It would be great if Duration were a standard formula that could be used in multiple columns.)

Thanks for the help.

Find more posts tagged with

Formulas

Services

Project Management

Comments

Scott Blick

I would utalize this functionality.

J. Craig Williams

For work days, see my comment in this thread:

https://community.smartsheet.com/discussion/day-count-formula-simple-one-i-guess#comment-17766

There is also an undocumented (use with care) formula CALCDURATION()

See this thread:

https://community.smartsheet.com/discussion/amount-working-time-between-tasks

Craig

Steve Averbach

Thanks much, Craig, for responding quickly.

I used the CALCDURATION function; however, I had to add a +1 to get the expected result: "=CALCDURATION([Actual Start Date]3, [Actual End Date]3) + 1". The NETWORKDAYS function produced the expected result.

J. Craig Williams

Steve,

You are welcome.

I don't use CALCDURATION - as they could turn it off without warning but know others that do.

Craig