Formulas with IF statements

WorkisWork
edited 12/09/19 in Formulas and Functions

I am working on if I have three sections and I only need to average one section because the other two are null, how can I write this out?

 

=IFERROR(AVG([% Complete]73, [% Complete]76, [% Complete]79, [% Complete]82, [% Complete]85, [% Complete]89, [% Complete]91, [% Complete]92, [% Complete]93, [% Complete]94, [% Complete]95), 0)

Here is what I am starting with.

Any help is appreciated...

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!