Metrics sheet, filter the data you pull back

Buster Davis

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?

Itai Perez

Hey @Buster Davis

Can you share some screenshots please?

You can use an automation to move rows to the metric sheet, do you want to count the number of instences of each initiative?

Some more information would help.

Andrée Starå

Hi @Buster Davis

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!