AVG COLLECT Formula using a contact column not working

Bobby Nelson

=AVG((COLLECT({Time to Audit}, {Audit Date}, <=DATE(2022, 1, 31), {Auditor}, CONTAINS("Marta Routt", @cell))))

This formula works when I have the Auditor column as a drop down and not Contact List. Why would that be?

Mike TV

@Bobby Nelson

Maybe the contact column really is their email address instead of their name? Have you tried replacing "Marta Routt" in the CONTAINS function with Marta's email address to see if you get results? If not, are you getting an error?

Bobby Nelson

The error I am getting is #DIVIDE BY ZERO. I have tried replacing Marta Routt with Marta's email address. When I do this I get the error #UNPARSEABLE.