Formula to use in the summary field for the number of rows within a specific column
Options
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

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?
Cheers.
Answers

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?
Cheers.

Thank you Jason
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!