NETWORKDAYS with IF

SueSus
SueSus ✭✭
edited 03/26/21 in Formulas and Functions

Hi

I have a NETWORKDAYS formula that will calculate work days between a begin and complete date, but often our projects are paused, so I need a formula that will subtract the net work days during the pause.

I figured that out, as well:

=IF([Completed Date]@row = "", "", NETWORKDAYS([Begin Date]@row, [Completed Date]@row) - [Total Pause]@row)

but now I get an "INVALID" if there is a Completed Date but no Total Pause entry.

I tried this:

=IF([Completed Date]@row = "", "", NETWORKDAYS([Begin Date]@row, [Completed Date]@row) - IF([Total Pause]@row > 0, NETWORKDAYS([Begin Date]@row, [Completed Date]@row) - [Total Pause]@row, ""))

But it only returns the Total Pause entry. If I change that - before the second IF to a , I get Incorrect Argument Set. Also, if there is no Total Pause entry, it's "Invalid operation".


Any ideas?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!