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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!