COUNTIF ... AND ... CONTAINS ...

Options

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

Answers

  • Jessica Griffin
    Jessica Griffin ✭✭✭✭
    Options

    @Brett Wyrick That worked. Thank you!

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!