Calculate Duration

Silvana Luna · 03/12/21

I'm new to Smartsheet, and I need help calculating the duration of a project based on estimated start date and estimated completion date. I tried the formula below but it didn't work.

=NETWORKDAYS([Due Date]@row,[Date Completed]@row

Kelly Moore · 03/12/21

Kelly Moore · 03/12/21

@Silvana Luna

Please make sure the column names in the formula exactly match your column names. It appears they do not. This will also produce an Unparseable error

Sam M. · 03/12/21

Yes, as KDM says, you have different names on the column types.

You have this:

=NETWORKDAYS([Expected Start Date]@row,[Expected End Date Completed]@row)

And it would be:

=NETWORKDAYS([Expected Start Date]@row,[Expected End Date]@row)

Kelly Moore · 03/12/21

You're welcome. As you build formulas, note the colors of your column names. If ALL of them within the formula are valid, the column names will be colored. If ANY of them are incorrect, none of the names will be colored. The parentheses are another indication. When you have the correct number of parentheses the last one should be blue. This does not necessarily mean they are positioned correctly, but the count of them is correct.

Thanks for contributing to the community. We all learn from both the questions asked and the questions answered.

cheers

Kelly

Kelly Moore · 03/12/21

Hey @Silvana Luna

With the exception of the formula above missing the ending parenthesis, it should work. When you say it isn't working - were you receiving the Unparesable error (from the missing parenthesis), a different error, or an unexpected result?

=NETWORKDAYS([Due Date]@row,[Date Completed]@row)

If this doesn't correct your problem, let me know and I'll be happy to help troubleshoot.

cheers,

Sam M. · 03/12/21

Hi Silvana,

I have a question,

Is the column type where you have your dates a Date Column type?

And is the column type for your result a Text/Number Column type?

I made some testing.

In the first section I have every column on Text/Number Column type, that causes an #INVALID DATA TYPE error. It might not understand what is being used in the date columns.

In the second section I have the dates in a Date column type and the result in a text/number column type.

To change a column type, you can double click on the column title and select the type that you want.

Hope it helps,

Samantha

Silvana Luna · 03/12/21

https://community.smartsheet.com/discussion/comment/283415#Comment_283415

I added the parenthesis and still got the #UNPARSEABLE error. See below:

Silvana Luna · 03/12/21

https://community.smartsheet.com/discussion/comment/283420#Comment_283420

Hi Samantha, yes to both questions and still getting the #UNPARSEABLE error. See below:

Kelly Moore · 03/12/21

Kelly Moore · 03/12/21