Incomplete work left to go

jacob sundermeyer
jacob sundermeyer ✭✭✭
edited 12/09/19 in Formulas and Functions

Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)?

It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. 

Is there another way to get there that I'm overlooking?

Screen Shot 2018-12-04 at 10.11.24 AM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!