How to Count Requests Submitted within a Certain Time Period


I am using a Smartsheet Form for users to submit requests to my team. I have a column that automatically generates when the request was submitted (month/day/year time of day). I need to be able to count how many requests we are getting for each hour of the day to justify shift hours for my team. Is there a way to calculate how many requests we've received at between 8:00 AM and 9:00 AM, 9:00 AM and 10:00 PM, and so on...?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!