i have spreadsheet of department's priorities , initiatives year, has 10-15 columns. i'd create series of executable buttons place @ top of report easy access filtering sheet values. example, 1 button may "show completed items" , when clicked script sort "status" column show rows completed value in column. trick here want these filters run clicking on image need done in script. i'm beginning user of scripts appreciated.
in sheet these column headers
col 1 pillar
col 2 strategy
col 3 initiative
col 4 priority
col 5 quarter delivered*
col 6 p&c owner col 7 partners
col 8 current status
col 9 start date
col 10 end date col 11 status notes
thank you
the best way save filters. saved filters accessible viewers.
for steps on how this, go filter data, scroll down see "create, name, , save filter view", select "create , save filter view"
after saved filter views, can access them drop down menu on filter button.
Comments
Post a Comment