#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




Forever forwards Backwards never.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!