Counting open tickets based on company name and ticket status



I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far:

=IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open"))

But I'm getting an INVALID OPERATION error. The Range 2 is checking to see if the company name matches to the company name on our ticketing sheet, and Range 3 is a ticket status column, formatted as a dropdown. Any help would be greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!