Find Average for days of completion based on category


I have created date submitted, dated completed and the total business days for completion. I would now like to take a category within the sheet and find the average days for completion for a category. I would also like to find average days of completion for assigned to.

Any help is appreciated

Thank you



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Angela Wright ,

    Your formulas will be along the lines of:

    =AVG(COLLECT([business days for completion]:[business days for completion], [category]:[category], [Category]@row))

    =AVG(COLLECT([business days for completion]:[business days for completion], [assigned]:[assigned], [assigned]@row))

    You'll need to replace the column names I used with your actual names.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Thank you Mark

    This is my first Dashboard, so I am a beginner. Please bear with me. I attempted the formula but still getting an error, "#unparseable". This is what I am attempting, referencing another sheet

    It seems that it guiding me to populate like this, but same error message

    Your help is much appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!