Metrics sheet, filter the data you pull back

So i have a main data sheet and it has a column called key initiatives. In that sheet, i can filter off of that column.

So now what i want to do is create a metric sheet that would only pull data from the source sheet that has the key initiatives box checked for that line item.

What formula could be used to accomplish this request?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!