Calculating Average Submissions Per Day Formula

Sam Clapp

I cannot figure out what formula to use, and what rows to use in order to calculate how many submissions a day I receive on my sheet. Does anyone have examples of how they've calculated. I have the following date-related columns:

Created Date

Due Date

Date Completed

Days to Complete (a formula using the due date & date added columns)

Thanks!

Brooke Y

Have you tried grouping by Count by Created Date? or using a sheet summary to average by created date count?

Sam Clapp

I'm not sure how to do grouping outside of reports, is that a feature? I do utilize the sheet summary--but I'm not sure which columns to leverage in order to get that "Average submissions per day" number.