How do I display the name of each program once in a metric sheet?

Hi, I'm trying to set up a metric sheet to do stats in the background of one of my sheets.

I have set up a sheet to manage analytics requests that we receive from five different program teams. The teams use a form to submit requests for analytics for their program. The sheet contains about 200 (and growing) requests submitted by the five programs. There are multiple requests submitted by each program and additional programs are going to be added throughout the year. I want to set up a metric sheet that will collect statistics for each program and I want the metric sheet to collect the new programs automatically. I have seen this done before (I believe with a combination of index and match formulas), but I can't seem to find that resource.

Does anyone have any insight on this? Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!