Sheet Summary equation


I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is unparseable. Help please!

Best Answer

  • cnikkih
    cnikkih ✭✭✭✭
    Answer ✓

    So right after I posted this, I finally found my answer. Sorry about that! I just didn't search long enough.

    In case it helps anyone else, my answer was this:

    =COUNTIF(Status:Status, "Not Started") + COUNTIF(Status:Status, "In Progress") + COUNTIF(Status:Status, "Failed")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!