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?
Help Article Resources
Check out the Formula Handbook template!