Formula to find how many requests a contact is assigned to

I have a sheet that tracks requests that come through a form. Each request then has a set of tasks that 3 teams need to complete. Within each request, there is 1-4 tasks that a contact can be assigned to. What formula can I use to show how many requests someone is assigned to? Right now I'm using a COUNTIF formula, but it is counting all tasks they're assigned to, where I would want it to only track the total requests they are responsible for.

Answers

  • I found a workaround. I'm having the COUNTIFS formula look for the specific contact name and only 1 of the tasks that would be required from that team. If there is an easier way to do this, I'm always up for learning :)

  • Hey @Taylor Riley

    It sounds like a COUNTIFS with multiple criteria is potentially the best way to go, I'm glad you figured it out!

    If this isn't working as smoothly as you'd like, it would be helpful to know a bit more about your process... screen captures of your sheet would be ideal, but please block out any sensitive data.

    Thanks!

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!