Help with totaling by date

HI I am needing help to total survey responses by date. The goal is to be able to have a chart that shows responses by day. So the users fill out a survey and the results come into the sheet. I then have a dashboard that gives the results for the day. However, what i want is a summary by day and this is where i'm struggling. For example, i would want 2/19/21 to be broken into the sum of the 3 choices: Full (6), So-so (9), Depleting (7). And I want this to be captured for each date. So far the survey has 2/17 to 2/23 as dates. I figure I need another sheet to reference and summarize but am struggling with the dates summarizing correctly so that a chart can be generated.

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Brendan Purkapile

Hope you are fine, you can use the following formula to count your responses by date

=COUNTIFS([How was your day today?]:[How was your day today?], "Full", Date:Date, DATE(2021, 2, 19))

to count for 19-Feb-2021 and response as "Full" for example

then you can change the criteria as you wish

Brendan Purkapile

thank you for the reply! I am also wondering how to make that formula work so that it can go day by day without having to enter a new date every time. I've tried to do a summary report but can seem to figure it out. Ultimately this data will feed into a chart on a dashboard that i have setup.

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.