AVG - COLLECT Formula Help


Hi y'all!

I am attempting to find the average days it takes to implement a project. I want to calculate data based on each project manager and also by what type of project they are implementing.

This is my formula but it is returning a "#DIVIDE BY ZERO" error:
=AVG(COLLECT({Time TI}, {Owner Last Name}, "Doe", {record type}, "Project Type 1"))

Attached you will find an example sheet of data I am calculating.

Can anyone help point me in the right direction? Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!