SUMIF formula within last 7 days


I need help with one of my formulas. I have an hours repository sheet where all employees log their hours. They include their names, week of (first Monday of each week) + number of hours spent on each project.

I am now creating a separate sheet where I need to pull the number of hours logged by each employee in the last 7 days. I keep getting the INVALID OPERATION error with my formula.

=SUMIFS({No of hours spent}, {Name}, =[Full Name]@row, AND({Week of} > TODAY(-8), {Week of} < TODAY(+1)))

Can you please help?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!