need a formula to return the number of forms filled out by a person(x) with a score of x

I need a formula that will return the total number of forms filled out by a specific person with a score of 5. It is cross sheet references and I am stuck. I have found some saying vlookup or countif. Butt neither formulas are working.

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @QA_Training_Agent3

    If you have multiple criteria that you're looking for (a person and a minimum score), then you'll want to use COUNTFS, plural! In this instance you won't need to say IF or AND again within the function, because it's already plural.

    A COUNTIFS Function works like this:

    =COUNTIFS({Column 1}, "Criteria 1", {Column 2}, "Criteria 2")


    So in your case, try this:

    =COUNTIFS({QA Team Weekly Reflection Sheet Range 7}, "Rose Kakuk", {QA Team Weekly Reflection Sheet Range 4}, 5)


    If you're looking for any score greater than 4, then you can adjust the criteria to this:

    =COUNTIFS({QA Team Weekly Reflection Sheet Range 7}, "Rose Kakuk", {QA Team Weekly Reflection Sheet Range 4}, @cell > 4)

    Let me know if this works for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!