how to publish with active pulldown to filter the displayed data?

Question

I want to publish all employee's name then I will provide a filter (maybe in the shape of pulldown choice). So the user can select from the pulldown, for example: male employee, female employee, an employee who age above 40 etc.

Is it possible in the publish page? any solution?

link: https://docs.google.com/spreadsheets/d/1gdvwnZk2w9eh0nhYIuqFiBAbu1Q1lByqLMqQhMmqF1s/edit#gid=0

@player0 Hi i just added the link. So i want to publish it to web and the user can interact with the pulldown , so they can select which data they want to view using the filter. Is it possible ? we can add function() to that pulldown but how to make the pulldown accessible so viewer can click it ? — andio

player0 player0 · Accepted Answer · 2019-09-13T14:47:50

formula would be:

=ARRAYFORMULA(
 IF(C2="All",      FILTER(A6:C, A6:A<>""), 
 IF(C2="Male",     FILTER(A6:C, C6:C="Male"), 
 IF(C2="Female",   FILTER(A6:C, C6:C="Female"), 
 IF(C2="Age > 35", FILTER(A6:C, B6:B>35), )))))

how to publish with active pulldown to filter the displayed data?

1 Answers