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
-
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
Answers
-
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
-
Thank you! That solved my issue :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!