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
Check out the Formula Handbook template!