Weighted Average With a Condition


Is it possible to gather a weighted average, with a condition?

My starting formula is

but I would like to build in a condition. In other formulas this has taken the form of

I can't work out how to bring these together / if it is possible.

Grateful for any thoughts anyone may have!




  • Brett Wyrick
    Brett Wyrick ✭✭✭✭

    Hey Emma. Trying to wrap my head around what you're trying to accomplish here, so couple of questions for you:

    Could you post a screenshot of the columns you're using? And what your use case is here, what you're trying to accomplish?

    I'm thinking you could utilize something like:

    =IF(SUM(CHILDREN([Not In Scope]@row)) >= 1, AVGW(CHILDREN(), CHILDREN(Weightage@row)))

    Which basically says, if the sum of the Children row column "Not In Scope" is 1 or greater, show me the original formula).

    Does that make sense? I think this ought to get you on the right track, at least.

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.


    Brett Wyrick | Connect with me on LinkedIn.


    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!