How do I total the answers from a drop-down cell?


I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.

The cell values are "Not Started" and "Completed". I simply want it to tell me how many cells in the column are at status completed and how many are at status not started.

I have pivot app which I didn't find achieved what I needed as it only let me tally the total number of cells in that column and not the total completed/not started.

Is there a formula that will accomplish what I want?

Best Answer

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

    Hi @BethWork

    I hope you're well and safe!

    Try something like this.

    =COUNTIFS(BannerName:BannerName, "Banner Name1", [Store Open]:[Store Open], "Open", [Install Status]:[Install Status], "Not Started")

    Did that work/help?

    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, Awesome, 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!