|

How To Clear Checkboxes With Google Sheets and Appscript

If you want to clear checkboxes by simply running a code, you need to know How To Clear Checkboxes With Google Sheets and Appscript.

Cleanshot 2023 02 11 At 23003386

Here’s a simple sample code:

function clearCheckmarks() {
 var range = SpreadsheetApp.getActive().getRange("B2:B8");
 var values = range.getValues();
 values.forEach(function(row) {
   row.forEach(function(col) {
     range.setValue("False");
   });
 });
}

In this case, “B2:B8” is the range of the boxes in my Daily Writing Habit Tracker that you want to clear.

You’ll have to swap out the range in your sheet that you want to clear.


The Nomad Brad
How To Clear Checkboxes With Google Sheets And Appscript 3

๐Ÿ‘‡Resources To Supercharge Your Marketing


๐Ÿ† How I’ve Been Earning Consistent Passive Monthly Commissionsโ€‹

๐Ÿ‘†Get The #1 Affiliate Training For 2022 ๐Ÿ‘†


๐Ÿš€ Best Affiliate Tools & Resources | <<< My Favorite Affiliate Resources

๐Ÿ”„.120 Top Recurring Affiliate Programs | <<< Download Free PDF

๐Ÿ“บ Check Out My Latest Youtube Video | <<< Good Stuff

๐Ÿ“ฒ Want 1-on1 Help With Your Business? | <<< Book A Coaching Call

๐Ÿ”ฅ Ready To Get Traffic With Bing? | <<< (Yes, It’s Still Working In 2022)

๐Ÿงฐ Digital Marketing Tools & Resources | <<< Speed Up Results With These

โœ… “Gamify” Your Productivity <<< Free Tool To Gamify Productivity

๐Ÿ“†ย Download My Commission Trackerย |ย <<<ย Track Commissions. Stay Motivated!

๐Ÿค– AI Tool I Use To Write SEO Articles | <<< Create Ranking Content On Autopilot

โš™๏ธ WP Plugin That Builds SEO Sites For You | <<< Create “Assets” On Autopilot

๐Ÿ‘‘ Good Course For Newbie Affiliates | Start With Free Traffic & Build Up

๐Ÿ“˜ Affiliate Book For Just $1 | <<< How To Get Started With Affiliate Marketing

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *