Combining Countifs and Week Number functions
Hello,
I am getting closer to solving this but am getting an Invalid Data Type error.
I have a sheet with dates and indented rows for employees (1 date per week on Mondays), and Column 3 is a helper column to refer to the parent. I am trying to pull the number of "complete" employees for this week as well as next week. The function I've tried is
=COUNTIFS({Recruiting Range 3}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()), {Recruiting Range 2}, "complete")
Is there something I'm doing wrong?
Answers
-
I believe I just answered this in your other post
=COUNTIFS({Recruiting Range 3},ISDATE(@cell), {Recruiting Range 3}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()), {Recruiting Range 2}, "Complete")
Please see the discussion here
https://community.smartsheet.com/discussion/82382/pulling-weekly-data#latest
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!