How to get a formula to count data on 2 sheets
We have an "assignment queue" worksheet that counts number of tasks assigned to each of our users. The users get assigned when a form is submitted to another sheet - how can we get the formula that counts number of assignments to look at both current assignments and new cases coming in since they are on 2 sheets?
Answers
-
Hello @Andrew M. you can use the COUNTIF and then Reference Another Sheet where you go into the other sheet and can select the tasks assigned column (with the numbers) this is your range in the formula and then the criterion would be the resource name, add FIND using the name of the user, @cell greater than 0 and return.
I haven't entirely tested your use case but ideally this or something similar should work.
Let me know what results you get and we can work more on this :)
Cheers!
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!