Home > Blockchain >  Create a custom menu in Google Sheets / Apps Scripts to hide and unhide column based on who is brows
Create a custom menu in Google Sheets / Apps Scripts to hide and unhide column based on who is brows

Time:04-12

I have a massive Google Sheet report that contains a lot of metrics. A lot of people in my company have access to this report and they all want to see different metrics.

So, I'm trying to create a button at the top of the report that hide/unhide columns depending on the person who is browsing the report.

    function onOpen(){
         const ui = SpreadsheetApp.getUi();
             ui.createMenu('Column Creation')
               .addItem('Add Column', 'insertColumn')
               .addToUi();
             ui.createMenu('View            
  • Related