Countifs for two criteria

Hi! I'm trying to do countifs for two different columns on a sheet, to account for how many of each Project Status type (In Progress, Backlog, Not Started, etc) there are for each Project Lead in my sheet.

I'm wanting to use this info so I can create a dashboard chart based off of the data. I tried the following, but keep getting unparseable.

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", [{Reporting Request Tracking Range 6}, "In Progress"])

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!