Sheet report Countifs - multiple categories by person


We use a metrics sheet to tally the number of design dept. requests (10 types), this then feeds to a dashboard for the Co. to see currents Dept demands. I've been asked to now reflect the number of requests by status (7 types) per design team member (4 staff).

I have individual totals, IE David 10, =COUNTIF({Request Tracker Range 3}, Category25. but can't work out the formula required to show the status Eg: of David's 10, 3 are In progress, 2 are Pending, 3 Not started etc etc. The source sheet has the columns next to each other "Assigned To" & "Status", everything I try I get different error's, help! Thanks Team.




Forever forwards Backwards never.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!