Summarizing items by country

Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new countries get added from time to time, and the manual list is then out of date.

Is there a way to do that?

Thank you!


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide some screenshots for reference?

  • Hi Paul - thanks for you jumping on this, you are always so helpful!

    I don't have a screen shot, but basically we have a sheet that tracks all of the case studies we create. We track them by region and by country. What I would like to do it have a formula (or something) that looks at all the content for EMEA and tells me there are 5 for UK, 6 for France, etc. without having to build a list of countries and calculate them all separately (that is what I have now, one formula per country: COUNTIF Country = France; COUNTIF Country = UK, etc.) but when a new country gets added, it won't get counted unless we add it to those roll up formulas.

    Does that help?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Have you looked into generating a report? Reports have summaries now that should be able to pull those counts for you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!