Countif completed last week

I am trying to write a formula that shows volume of work completed last week. I am getting a result, however it is not grabbing the full list of data. I have played around with different day ranges but it doesn't seem to change my result. The formula I have references other sheets. Please see attached images. I have added a filter to the source sheet to show what should be captured.

=COUNTIFS({Completed Files Focus Tracker Range 1}, [Assigned to]@row, {Completed Files Focus Tracker Range 2}, "Initial", {Completed Files Completed week}, =WEEKNUMBER(TODAY(-1)))



Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!