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,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!