Countifs formula

Hobo
Hobo ✭
in Formulas and Functions

Hi Team reaching out for some help again, i need a countifs formula to count all the high priority actions (Priority column) that are currently either not started or ongoing (Status column)


image.png

Thanks in advance

· Share on FacebookShare on Twitter

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    Hi @Hobo ,


    You can use this formula. The formula will count rows where priority is high and status is not completed.


    =COUNTIFS(Priority:Priority, "High", Status:Status, <> "Completed")

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

    · Share on FacebookShare on Twitter

Answers

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!