Filter Help
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.
Best Answer
-
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.
Answers
-
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.
Regards - JC
-
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?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives