Combining Countifs and Week Number functions

Desertbird

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?

Kelly Moore

@Desertbird

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