AverageIF or Avg(Collect) formulas
Options
Answers
-
AVG(COLLECT(..........)) should work too and requires less typing (and less cell references if you are in danger of hitting those limits). Are you able to provide the AVG/COLLECT you were using that was causing the error?
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!