Avg Collect Formula Error

I am attempting to create a formula for a dashboard that pulls data from a sheet and needs to reference the amount of days from Approved to contacted for a specific Agent and by Month. I tried to use several formulas starting with the following:

This pulls back all 0's.

I also tried this formula and got the error #Divide by Zero

I would appreciate any help I could get to understand where my errors are!

Find more posts tagged with

Formulas

Accepted answers

All comments

Michelle Choate 2

What 0s is it pulling back? From what column? Do you have a screenshot of a sheet you can share that shows the columns you are looking to pull in?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.