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
-
If you just take out the last statement, then it won't filter by client and will only look at the first 2 conditions. It would look like this:
=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent")
-
Thank you. It works great.
-
Awesome. Glad it is working.
Answers
-
If you just take out the last statement, then it won't filter by client and will only look at the first 2 conditions. It would look like this:
=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent")
-
Thank you. It works great.
-
Awesome. Glad it is working.
-
Hi David,
Would it be possible to extend this formula to identify which month this Item was issued when the date formula on the data sheet is in the following format 10/01/2020? If the item was issued within the last month or 30 days, count it.
Let me know.
Thanks.
Chareese
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!