Formula to use in the summary field for the number of rows within a specific column


For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.

Best Answer

  • Jason P
    Jason P ✭✭✭✭
    Answer ✓

    Hi @hhsinnovation

    Assuming you have set up the column for Symbols (Red/Green/Orange) you can use =countifs setting up one summary formula for each colour =COUNTIFS(column name:column name, "green")

    Would this work for you?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!