COUNTIFS formula troubleshooting in Sheet Summary


I have form that has Site Location and two separate checkbox options, where either both requirements will be checked for New Hire or only the latter for Existing Employee. I'd like to create a Sheet Summary formula to COUNTIFS a certain Site Location is selected and if the New Hire checkbox is selected, I want to get a count of each per site, but my formula isn't working and I'm not sure what the error is. Here is my current formula, but I'm not having any luck. Ideas?

=COUNTIFS(Site Location:Site Location, Site 1, [New Hire:New Hire, 1])

Best Answer

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    edited 11/16/23 Answer ✓

    Hello @KarenTF

    Hope you are doing well. Try adjusting your formula - adding brackets and quotes around "Site 1".

    =COUNTIFS([Site Location]:[Site Location], "Site 1", [New Hire]:[New Hire], 1])

    Thanks, Peggy


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!