Formula to display duration of a project

Adolfo E. · 02/15/19

Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?

Nic Larsen · 02/15/19

If you enable Dependencies under the project settings it will auto add a duration column. Assuming you indent all your tasks to your first row, it'll capture your total project duration.

Mike Wilday · 02/15/19

In addition to that, you can also use the networkdays, or netdays formula to calculate the number of working days or calendar days between the first and last date in the project...

https://help.smartsheet.com/function/netdays
https://help.smartsheet.com/function/networkday (Adds 1 day for some reason)
https://help.smartsheet.com/function/networkdays

Formula to display duration of a project

Comments

Help Article Resources

Categories