Clear Task Row With One Click in Google Sheets
Learn how to clear a task row in Google Sheets with just one click using checkboxes and a simple Apps Script. This video also introduces Sheet Ops, a powerful task management tool with automation features.
To clear a task row with one click, we're going to need to do a couple things. We want to delete the data , but not any sort of formatting . One, we're going to have to add a checkbox column and write a little appcript, but it's simple. I'll walk you through. Let's insert a column. Let's insert checkbox . Now, this is going to be our clear column. Once we check that box, we want to just clear the data or the content in that row. Let's go up to extensions, appcript.
Now, if you don't want to write any appcript whatsoever, let me share with you that I have a fully automated business operations task manager already built. It's called sheet ops. You can get it today. Buy it today and it comes off the rack with so many automations, including sending tasks to Google tasks for yourself or delegating them to others with Google calendar. Quickly email from here, WhatsApp, Telegram, SMS, even write your own emails to follow up and quick reminders. Really really cool stuff here. But back to the task at hand. Let's write a little bit of appcript. We need a function onedit with an event.
E. range .getcolumn. And so if column is equal to, meaning two equal signs, one, then what are we going to do? We want to go from the second column over to the right. Get that whole range and clear the content. Let's go. Spreadsheet app.get active spreadsheet . Get active sheet . Get range . Range is going to be the row we're on. column 2 starting the number of rows we only want one row and the number of columns is going to be max columns well we need another variable max columns so variable max columns is equal to we're just going to get all of that dot get maximum columns and we can clear content clearing content is just going to delete the data we also want to
do one more thing which is let's take this exact same range copy and paste it But instead of column two, we're going to go to column one. And we're only going to do one, comma, one, meaning one row, one column. And we're going to uncheck it. That's because we know it's a checkbox column. And when it's checked, we want to clear it. And then uncheck it. So let's make sure we have everything saved. And let's try clearing the second row. There it goes. It unchecks it. And it clears everything, but it keeps these drop-own menus intact. Isn't that cool? And so you can clear a task row with just one click. But if you're looking to do way more with your tasks, either assign them to yourself or others, check out sheet ops. It's available today. Get it, grab it,
use it. All these awesome features like emailing a weekly report is possible of all the tasks you're doing and what's their progress. You're watching Better Sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is going to be your next Google Sheet.