I need help completing an If statement to calculate networkdays when a condition is met

Options

I have the need to calculate the amount of days a record was open or is currently open. I keep getting errors in the formula. I have the below screen shot for reference.

So, when Progress tracking = complete I need the networkdays from Created to Completed and when Progress tracking <> complete I need the networkdays from Created to Today's date. Any assistance you have is greatly appreciated. :)



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!