Count of activities during current week

Nisa Shepard-Carter

Hi there,

I'm trying to get a count of certain activities taking place during the current week to get an overall view of how many activities my team is completing in a week. The formula I am attempting to use is:

=COUNTIFS(Complete:Complete, "1", Helper:Helper, WEEKNUMBER(TODAY()))

Complete = Checkbox Column that helps me track when an activity has been confirmed

Helper = Additional column added to record an auto creation date since the date I want to use sometimes includes a time (HH:MM)

The formula above gives me a "0" and I have read through all the posts to figure out what I'm doing wrong. Any help is appreciated.

L_123

Original

=COUNTIFS(Complete:Complete, "1", Helper:Helper, WEEKNUMBER(TODAY()))

Issue 1

"1" means you are looking for text, a checkbox is represented by integers 1 and 0

Issue 1 Fixed

=COUNTIFS(Complete:Complete, 1, Helper:Helper, WEEKNUMBER(TODAY()))

Issue 2

WEEKNUMBER(TODAY( this does not check the year

Issue 2 Fixed

=countifs(complete:complete,1,helper:helper,and(@cell > today()-weekday(today()),@cell <= today(7)-weekday(today(

Give that a try and see if it fixes your problem.