David Slaughter
David Slaughter ✭✭✭
edited 04/21/20 in Formulas and Functions

Hi All,

I'm trying to run a query to group and count certain status' in order to count them as a single statistic.

For example: If there's 4 'New / Reported' tickets and the 'Pending External Clariication' has 5 tickets, the OPEN tickets box would show 9 OPEN tickets.

Ticket classes:

Open ticket = The status' (New / Reported, Pending External Clariication, Pending Internal Clarification)

Closed tickets = The status' (Resolved / Released, Rejected)

I've managed to understand a lot of the other query structures but seem to be really struggling here, so was hoping someone would be able to help!

String I put together below:

=COUNTIFS({Change Request & Feedback Form Range 1}, [Status] : [Status], "New / Reported", "Pending External Clarification")

Thanks, David

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!