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
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.
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.
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,
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:
That worked! Thank you KDM
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.