Average duration for specific owners

Hello,

I am trying to create a formula that averages the days from a "duration" column for a specific project owner (I have the project owners listed in "Column 7"). I continue to get an "Invalid Operation" message.

Formula:

=AVG(COLLECT({CSS Prioritization Duration}, {Owner}, HAS([Column7]@row)))

Answers

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭

    I think using AVERAGEIF() would be the best way to calculate this. It would look like:

    • =AVERAGEIF({Owner}, CONTAINS([Column7]@row,@cell),{CSS Prioritization Duration})

    Hope this helps!

    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!