Automating Formula to Determine Submissions per Week

Hello,

I am working on making a sheet that tells me how many submissions we had in a weeks time and want to automate it using two date columns and referencing the intake sheet it is coming from.

I'm currently trying to use the =countifs function and reference the dates next to it but it does not seem to work. This is my current formula: =COUNTIFS({Master Intake Help Column}, "1", {Master Intake Submitted Date}, >=DATE([Week Start Date]1), {Master Intake Submitted Date}, <=DATE([Week End Date]1))

I've attached the sheets at play for reference. Would appreciate any insight! The intake form is the top photo and sheet I am trying to get the formula in is on the bottom. Thanks!

Find more posts tagged with

Account and User Management

Accepted answers

All comments

Bassam Khalil

Hi @samwex

Hope you are fine, please try the following formula:

=COUNTIFS({Master Intake Help Column}, @cell=1, {Master Intake Submitted Date}, @cell >=DATE([Week Start Date]1), {Master Intake Submitted Date}, @cell <=DATE([Week End Date]1))

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.