Query the number of entries in the latest week

Alberto CONCEJAL LÓPEZ

Hi, i need to count the number of entries matching this criteria,

*1 certain person in a column (this is a list of different emails)

*the actual week (I have a column capturing WEEKNUMBER and a cell capturing the MAX value meaning the actual)

The expected result is a number for instance certain person has added 5 entries this week,

Thanks!

Alberto

Find more posts tagged with

Accepted answers

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

You would want something like this...

=COUNTIFS([Email Column]:[Email Column], "Email.address@email.com", [Date Column]:[Date Column], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()))

Alberto CONCEJAL LÓPEZ

Not sure what is going on but this one is not working. Can it be addressed some other way?

Could it be due to my weeknumber column is written like this =WEEKNUMBER(ACQUISITION@row)

I have ahnother column called acquisition date

Thanks!

Alberto

Paul Newcome

This formula bypasses the need for a separate column to address the week number by evaluating the week number of the date column itself within the COUNTIFS. Here it is updated with the appropriate date column name in place.

=COUNTIFS([Email Column]:[Email Column], "Email.address@email.com", ACQUISITION:ACQUISITION, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()))

Alberto CONCEJAL LÓPEZ

Thanks for your help, i couldnt make it happen so i made a plan B and it worked,

=COUNTIFS({QCTEAM_4}, ="name@email.com", {WEEK_3}, =WEEKNUMBER(TODAY()))

it seems i had an issue related to referring two different sheets from my metric's,

Thanks anyway! i will keep on asking most definitely,

Regards,

Alberto

Paul Newcome

Happy to help. 👍️

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.