Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    COUNTIFS formula troubleshooting in Sheet Summary

    ✭✭✭✭✭
    in Formulas and Functions

    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])

    · Share on FacebookShare on Twitter

    Best Answer

    • Community Champion
      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

      · Share on FacebookShare on Twitter

    Answers

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions