The latest articles on DEV Community by gDevTest (@gdevtest). https://dev.to/gdevtest https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F935845%2F038eeb44-d80b-4f73-8397-266a7b944944.png https://dev.to/gdevtest en gDevTest Sun, 02 Oct 2022 04:50:02 +0000 https://dev.to/gdevtest/how-to-hideunhide-columns-with-google-appsscript-co9 https://dev.to/gdevtest/how-to-hideunhide-columns-with-google-appsscript-co9 <p>Hello,<br> I'm a beginer in js &amp; google apps script and trying to get this done to no avail...<br> I've divided my google sheet in 3 working zones [Range1(E:I), Range2(J:N), Range3(O:S)]<br> so, I'm trying to write a script to hide and unhide each range in the way that <br> if Range1 is showing/unhidden, Range2 &amp; Range3 should be hidden and so should it be for the other 2 ranges...<br> The script I tried to write(see below) for Range1 returns no error; but won't do anything either</p> <p>Please your contribution and help will be apprciated...</p> <p>=============</p> <p>function hideRange1(){<br> var wb= SpreadsheetApp.getActiveSpreadsheet();<br> var sh= wb.getActiveSheet();<br> var range1= homesh.getActiveRange(E:I);</p> <p>if (range1.getA1Notation() !="E1:I") return;</p> <p>if(range1=="True"){<br> SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().hideColumns(10, 19);</p> <p>}<br> else if (range1 == "FALSE") {<br> SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().showColumns(10, 19);<br> }<br> }</p>