Using countifs formula

Shane Cornwell
edited 09/06/20 in Formulas and Functions


I have used the COUNTIFS formula successfully in the past when pulling the status and date off a workspace. An example of the formula used is below:

=COUNTIFS({Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)))

However, I now need to be able to pull the same information as above, except I need to incorporate the name of the person who worked the task order. Is there a way I can easily add that into my existing formula or am I way off base? Any help would be greatly appreciated.


Best Answer


  • Shane Cornwell

    The best solution is usually the simplest... lol 😊

    Thank you greatly for the help, that did the trick. I appreciate the help on this one.


  • Genevieve P.

    Great! So glad it worked for you 🙂

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!