Track Form Submissions By Date

My organization has several forms set up that are utilized quite a bit. I'd like to track how many forms are submitted on a given day, week, month, quarter. I have tried countifs, and a whole bunch of other formulas. I also made a report but I am unable to pull report metrics into a dashboard so that it can visualized easily in a chart. Is there a formula I can use on a metrics sheet that will allow me to track how many forms are being submitted daily, weekly, monthly, quarterly? When a form comes in, it has a date field.

Find more posts tagged with

Workload Tracking

dates

Accepted answers

All comments

kowal

hi @Jehan,

If I were you I would use for that the Date Created column which will always give you a date when the Form was submitted.

In the sheet summary you shall use function =countifs()

so for march it should be sth like: =countifs ([date created]:[date created], < 31.03.2025, [date created]:[date created], > 01.03.2025) etc. I am from Poland we have different date format etc. but I guess you get the point.

Hope it helps

Jehan

Hi Kowal, Thanks for your suggestion, but it's not working. I might be wrong, but it looks like the formula you sent me might be an excel formula. The syntax in Smartsheet is different.

Here is my confusion, when I start typing out the formula you suggested like this:

=COUNTIFS({ these are curly brackets, not a ([

Also, I am referencing another sheet, it's called Jehans Report to pull into my metrics sheet. The column is called "Submission Date" and I understand in your example you are using the "Date Created" column, but I doubt that should make a difference, right? My formula says

=COUNTIFS({Jehans Report - Submission Date} : {Jehans Report - Submission Date}), < 11.30.2020, {Jehans Report - Submission Date}, > 11.01.2020)

It's not even allowing me reference another sheet after the , > so this isn't working. If I type out : {Jehans Report - Submission Date}) before the > 11.01.2020) it still won't work.

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.