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?
