|

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 *