Count of activities during current week
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.
Best Answer
-
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.
Answers
-
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.
-
That worked perfectly...thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!