Multiple Duration Columns

Steve Averbach

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.

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