referencing another sheet I need all clients in the client column, I need All Clients


My formula is as follows for 1 client: AFR

=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent", {LPSC tickets Range 3}, "AFR")

There are 10 different clients in {LPSC tickets Range 3} - these clients are used various times throughout the data.

Question: How do I find out the number of tickets for all clients? Should I use COUNTIFS or another formula?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!