Combining Average and Rounding up to x.x



I need some assistance on a formula that will take the average of multiple numeric columns and then round to the nearest 1.0 [first decimal]. For instance, 1,1,3 average up to 1.666667 - I would rather just have this round up to 1.7.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!