Need help fixing this

Kyle Black
Kyle Black ✭✭✭✭✭
in Formulas and Functions

=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

· Share on FacebookShare on Twitter

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"))

    · Share on FacebookShare on Twitter

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"))

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!