AVERAGEIF or AVG ??????Why is this not working and how do i get it to work
Options
SharonR
✭✭✭✭✭
So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please help
the formulas i though should work in the purple #invalid data type is =AVERAGEIF(CHILDREN(Completed91), ="Completed", CHILDREN())
Tags:
Answers

Wrap your formula in the red row in an IFERROR statement. That should remove the error and allow the other formulas to run.
=IFERROR(original_formula, "")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!