COUNTIFS / Referencing data another sheet

Nic Larsen
Nic Larsen ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm still pretty new to Smartsheet. My goal is collect data from another sheet in an easier to read format but I cannot get my COUNTIFS formula to work. If I do separate formulas for each criteria it will work but not when I attempt to combine the formulas to look at 2 criteria's it fails. 

I have columns on the referencing sheet with Team Names (accounting, finance, compliance, etc) and Status column (On Time, Complete, Late, etc). I have inserted references on that range of columns.

Reference sheet is "Program1"

=COUNTIFS({Program1}, "Accounting", {Program1}, "Complete")

=COUNTIFS ({Program1}, "Accounting", {Program1}, "Late")

I want a total count of when the team name has a task showing as complete, late, etc.

I have researched up and down and cannot get anything other than an "unparseable" return.

What am I missing? Any help is appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!