AVG - COLLECT Formula Help

Natalie K

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

Uploaded Jun 6, 202441.54 KB

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

Denden8706

THIS SHOULD HELP.

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

Denden8706

THIS SHOULD HELP.

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

Natalie K

Amazing, that did it. Thank you so much!