COUNTIF ... AND ... CONTAINS ...
I am trying to count a source sheet if it's and new request and the Business area is HR
I have tried the following
=COUNTIF({Internal Comms Intake Range 2}, "New Request",({Internal Comms Intake Range 3},CONTAINS("HR",@cell))
Came back Unparseable
=COUNTIF({Internal Comms Intake Range 2}, "New Request", AND({Internal Comms Intake Range 3}, "HR"))
Came back Incorrect Argument Set
Best Answer
-
Hey Jessica - I think you're closer on your second formula.
Instead of COUNTIF and AND, just use COUNTIFS:
=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")
Report back and let me know if that works!
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Answers
-
Hey Jessica - I think you're closer on your second formula.
Instead of COUNTIF and AND, just use COUNTIFS:
=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")
Report back and let me know if that works!
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
-
@Brett Wyrick That worked. Thank you!
-
Glad to help! Can you mark the "Answer" above as "Yes" so this shows as closed? Thanks!
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!