How to get a formula to count data on 2 sheets

Options

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

  • Ipshita
    Ipshita ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!