AVG - COLLECT Formula Help

Question

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.

Smartsheet Example.png

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

Denden8706 · Accepted Answer

THIS SHOULD HELP.

=IFERROR(AVG(COLLECT({Time TI}, {Owner Last Name}, "Doe", {record type}, "Project Type 1")),"0")