Average duration for specific owners


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.


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


  • 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!


    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!