Calculating Average Submissions Per Day Formula
Answers

I would also like to find a formula to use to count submissions per day and return an average.

@Sara Kouba would this work for you? My example uses Absence Date, you would replace that with Submission Date and have your average. I hope this helps!
=COUNT([Absence Date]:[Absence Date]) / COUNT(DISTINCT([Absence Date]:[Absence Date]))
In my example sheet here I have 4944 entries/submissions, on 35 different days (used DISTINCT in the formula so I can count the unique days to divide the submissions by). 4944 (first half of formula) divided by 35 (second half of formula) comes out to 141.25 submissions per day. I don't usually do things like this in the same sheet where the data is, but wanted to put this in an easy to screenshot view :)

I will try this! Thank you! My ultimate goal is to get this information onto a dashboard. I would love to do so with a way to have drop downs on the dashboard to specify a range of time to calculate the average submissions between the two dates. I have to do this to get information for 26 separate, but identical, sheets.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!