Filter Help

Radhika

Need a dropdown option for "Impacted Teams" in a cell, so that it can filter out all the rows in the tables with the value.

adp_cl

It appears that you're attempting to house a table within the sheet (different columns for different groups of rows). I do not believe that you will be able to accomplish that. If you adjust your data to not have "stacked" tables within the sheet, you will be able to filter using @Jeremy C 's instructions.

Jeremy C

To make a column into a dropdown:

Right click on the column header -> Edit Column Properties -> Column Type then set it to dropdown list. Enter your dropdown selections and click Ok.

Then create a filter based on your needs for that column.

Genevieve P.

Hey @Radhika

I see that you marked JC's answer as not helping your question - can you explain further what you are looking to do?

Do you mean that you're trying to build a formula to create a number, based on the text in the Impacted Teams column?

Radhika

S1.PNG

Please see the attached image, table starts from row 8 Column impacted team row 1 should be the filter for that table which should provide the resultset. Also Need a dropdown for the table. When i'm selecting particular team I want the table to show all the resultset of the team along with calculation for sprint data(Sum). Filter dropdown will also help us give the total head count from different sheet.

Thanks,

Radhika

adp_cl

It appears that you're attempting to house a table within the sheet (different columns for different groups of rows). I do not believe that you will be able to accomplish that. If you adjust your data to not have "stacked" tables within the sheet, you will be able to filter using @Jeremy C 's instructions.

Radhika

Thank you all for the insightful information. The view that I'm trying to achieve is not possible. I can get the data through different calculation, but not able to achieve the view that is expected