Which formula do I need if I want to count issues assigned to 2 people that are counted for each ind

Options

Hi everyone,

I am fairly new to Smartsheet and this is my first question in this community!

I have an Issue Tracker where issues can be assigned to multiple people. On one of the charts on my dashboard I am showing how many Issues are assigned to each individual. I have a formula that counts if an issue is assigned to 1 individual. For example: =COUNTIFS({Issue Type}, "ISSUE", {Assigned To}, "Tom Smith")

I the occasion where issue/task is assigned to 2 or more people I need a formula that would count that issue and add it to all individuals assigned, and I can't figure it out. So for example if 1 issues is assigned to Tom and Donna, I need this same issue to count for Tom AND Donna. Does anyone have an idea how to solve this?

This were two of my failed attempts:

=COUNTIFS({Issue Type}, "ISSUE", {Assigned To}, "Tom Smith") + COUNTIFS({Issue Type}, "ISSUE", {Assigned To}, "*Tom Smith*")

=COUNTIFS({Issue Type}, "ISSUE", {Assigned To}, "Tom Smith") + COUNTIFS({Issue Type}, "ISSUE", {Assigned To}, "*Tom Smith*,*")

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @LeaVol

    I just have a couple of questions to better build you the proper solution. First would be have you attempted using the OR function. Secondly could we get a screen shot of what your working with for some more context. YOu can clean this of any sensitive information. Third. When you are assigning something to multiple people. IS it from a mult-select drop down?

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!