COUNTIFS - Referencing a Status column in another sheet

I am trying to create a metrics grid that will count tasks assigned to individuals based on the documented status and keep getting either an #Unparseable or an #Incorrect Argument error. In the screenshot below, I've captured the working formula for the Total Assigned column and two variations of what I've tried to do in the In Progress column. I'd be grateful for any suggestions you could share!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!