Help needed on COUNTIFs formula in Summary Sheet


I was creating a summary sheet for my data to count only entries which are showing as "TMU Elevate" under column "Training Program" and those who are marked as "Completed" under "Status" column. Below is the syntax I entered but I keep getting #UNPARSEABLE return. I have tried adding $ too before each column name but same issue I am getting. What is wrong with my formula?

=COUNTIFs([Training Program]:[Training Program],"TMU Elevate", (Status):(Status),"Completed")

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Abby Cruz

    I hope you're well and safe!

    Are you adding this to another sheet you call Summary Sheet or in the Sheet Summary section?

    If it's the second option, try something like this.

    COUNTIFS([Training Program]:[Training Program],"TMU Elevate", Status:Status,"Completed")

    Did that work?

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!