Calculate Duration
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
Best Answers


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

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)

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
Answers

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,

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

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

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


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

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)

That worked! Thank you KDM

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