Need help fixing this

=COUNTIFS({Behavior Based Safety Observation Range 4}, OR("no action need","complete", @cell)), {Behavior Based Safety Observation Range 2}, CONTAINS("STS - Operations (welding)", @cell))


First one i want it to count no action need or complete the second count welding department entries

Best Answer

  • Kyle Black
    Kyle Black ✭✭✭✭✭
    Answer ✓

    Nevermind I got it


    =COUNTIFS({Behavior Based Safety Observation Range 2}, @cell = "STS - Operations (welding)", {Behavior Based Safety Observation Range 4}, OR(@cell = "Action Complete", @cell = "No action need"))

Answers

  • Kyle Black
    Kyle Black ✭✭✭✭✭
    Answer ✓

    Nevermind I got it


    =COUNTIFS({Behavior Based Safety Observation Range 2}, @cell = "STS - Operations (welding)", {Behavior Based Safety Observation Range 4}, OR(@cell = "Action Complete", @cell = "No action need"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!