Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Metric Sheet Calculations for a Dashboard
Evening All,
i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare.
=IFERROR(AVG({Sales Variance}), "")
Many thanks,
Sarah
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!