Create unique list that populates a second sheet (not report)?

Hello, I'm having trouble figuring out the correct formula to populate a list of unique locations and totals their entries on a second sheet. I couldn't find a forum example that doesn't use a report. This needs to be on a second sheet because it will be used in other formulas and dashboards.

Sheet 1 includes a list of locations, activities, and results. It will continue to populate new rows that are generated from a form.

Sheet 2 needs to list the unique locations and total their results:

I've fussed with INDEX/DISTINCT/COLLECT and it's not working. Thank you for your help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!