Counting weekly entries from a Created By field

I am looking to count all the entries from a Created By field in Sheet 1 and deposit that count into a Sheet 2 that contains rows for each week of the year 1-53. The intended use is to show week over week counts of inquiries. Will eventually want to specify the count per support type for each column on Sheet 2 (Sales, Training, etc), but will have to walk before we can run, so any help would be appreciated).

Sheet 1:

Sheet 2:

I have tried:

=COUNTIF(WEEKNUMBER({Created Date}), WEEKNUMBER([Week Number]@row))

and several variations with no success.

Find more posts tagged with

Accepted answers

All comments

isa.ohara

I believe what needs to be done is to add a helper column to your sheet that stores the WeekNumber - it can't pull the WeekNumber from the Range - and then get rid of the "WEEKNUMBER" for the WeekNumber@row

So it would be: =COUNTIF({WeekNumberColumn}, @cell = [Week Number]@row)

I was trying it out and had the same problem

crodts

Is there a way to do this without adding a helper column to Sheet 1? The rows in this sheet copy to many more sheets and I would like to avoid having a Week Number column copied over to the other sheets each time.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.