countif help


Hi Folks

hoping i can get some assistance

I have a large tracker that is tracker COVID isolations and test results.

i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard

I made a Weeknumber helper column, the week number will generate if - Positive is checked and based on the Test Result Date

here is the formula I have written, but isnt returned a count for me

=COUNTIFS({Isolation and Absences Range 66}, [Last Week]@row, {Isolation Tracking Range 2}, =1)

Isolation and Absences Range 66 is the column where the if/weeknumber is generated

Isolation Tracking Range 2 is the Positive column (checkbox)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!