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
- Smartsheet Customer Resources
- 62.4K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!