Metric Sheet Calculations for a Dashboard
Options
Comments
-
Try using an AVERAGEIF statement along the lines of...
=IFERROR(AVERAGEIF({Sales Variance}, <> 1), "")
-
Thank you! That looked to work!
-
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!