#Invalid data type - Countifs on two category's.

Hi, team.

Difficulty in nailing the formula..

Sourcing data from our Design sheet I'm trying to count for each of our sales team members how many requests they have lodged (10 requests types) & of those how many of them are at each status (7 types). IE, I could have 10 at Drawing only& of those 4 at "In Progress", 2 at "Not Started" etc. This data will feed to a dashboard.

Hope you can help

Regards

Jason

Cheers.

Forever forwards Backwards never.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!