Networkdays problem

GoGophers22

Hi, I keep getting an #Unparseable error. Here's my function:

=NETWORKDAYS([IRB Submission Date]1, [IRB Approval Date]1)

Any thoughts?

Paul Newcome

Double check that your column names are correct. Instead of manually typing them, try clicking on the cell you want to reference in the formula so that smartsheet automatically populates the column name to make sure that it is an exact match.

GoGophers22

That was it! I had the correct names, but it wasn't pulling it in for some reason. Clicked on them and that solved it! Thank you!!

Paul Newcome

Just a misplaced parenthesis.

=IFERROR(NETWORKDAYS([IRB Submision Date]@row, [IRB Approval Date]@row), "")

=IFERROR(original_formula, """)

You want to drop your original formula into the first portion of the IFERROR (excluding the initial "=").

Paul Newcome

Double check that your column names are correct. Instead of manually typing them, try clicking on the cell you want to reference in the formula so that smartsheet automatically populates the column name to make sure that it is an exact match.

GoGophers22

That was it! I had the correct names, but it wasn't pulling it in for some reason. Clicked on them and that solved it! Thank you!!

Paul Newcome

Happy to help. 👍️

GoGophers22

Also follow-up question - how do I use the IFERROR function?

Tried this but not working...

=IFERROR(NETWORKDAYS([IRB Submision Date]@row, [IRB Approval Date]@row, ""))

Thoughts?

Thank you again!!

Paul Newcome

Just a misplaced parenthesis.

=IFERROR(NETWORKDAYS([IRB Submision Date]@row, [IRB Approval Date]@row), "")

=IFERROR(original_formula, """)

You want to drop your original formula into the first portion of the IFERROR (excluding the initial "=").

GoGophers22

SUCCESS! Thank you so much!!!!

Paul Newcome

Happy to help. 👍️