Count If referencing other sheets


Hi! I am looking to create a Count If function that references other sheets.

Using the example below, in the Opportunity Tracker sheet, I am looking to create the function in the Staff Allocated column. For each unique Client + Opportunity Name pairing, I want to determine the count of resources "Accepted by client". Each of the other sheets are named based on the Client column and they would need to reference the Opportunity Name and Engagement Status columns in those client sheets.

For reference, here's what the results should yield.

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!