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
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!