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!
Answers
-
Have you tried grouping by Count by Created Date? or using a sheet summary to average by created date count?
-
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.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!