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.

    Help with COUNTIFS Formula w/ multiple possible criteria in the same column

    ✭✭✭✭✭
    in Formulas and Functions

    I am looking to create a formula that can count a couple of items and if any of 3 possible solutions are in play. Any help that anyone can lend would be appreciated.

    Items I am looking to count:

    'Carrier Initiated TDM' is checked and the status is 'In Progress' and if the Scope/Decision/Solution is any of these 3 possible scope options:

    'Add Temp Cell'
    'Add temp cell, Disconnect'
    'Disconnect, Add temp cell'

    What I have tried for a formula - but its returning 0:

    =COUNTIFS({T1 Scope}, "Add temp cell, Disconnect", {T1 Scope}, "Add Temp Cell", {T1 Scope}, "Disconnect, Add temp cell", {Carrier initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress")

    Here is a snip of my sheet:

    image.png
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • Community Champion
      Answer ✓

      @PKane

      Try this:

      =COUNTIFS({Carrier Initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress", {T1 Scope}, OR(@cell = "Add Temp Cell", @cell = "Add temp cell, Disconnect", @cell = "Disconnect, Add temp cell"))

      Will this work for you?

      Kelly

      · 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