Formula assistance

Susan van Niekerk

Susan van Niekerk ✭✭✭✭✭

06/23/23 in Formulas and Functions

Hi All,

In the Average Health column I will like to average the row BUT not include in the count any cell that has a "0"

0 ·

Answers

Carson Penticuff Community Champion

06/23/23

There is a function built in for this specific use case.
=AVERAGEIF([Strongly Agree]@row:[Strongly Disagree]@row, > 0)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…
Formula help
This discussion was created from comments split from: Sequential numbering of duplicates.
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…