# Query the number of entries in the latest week

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

## Best Answer

• ✭✭✭✭✭✭
Answer ✓

Happy to help. 👍️

## Answers

• ✭✭✭✭✭✭

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()))

• 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

• ✭✭✭✭✭✭

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()))

• 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

• ✭✭✭✭✭✭
Answer ✓

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!