Using countifs formula

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

Hello,

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.


Thanks

Best Answer

Answers

  • Shane Cornwell
    Options

    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.

    Thanks!!

  • Genevieve P.
    Options

    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!