Google Sheets - Self-Sorting Task List ☑️

[@SheetsHelp]

Script editor moved to Tools -> Apps Script

[@yannagabriel9441]

This might be helpful for some of you, I was having the same issues with the error codes. I ended up deleting it out, and restarting. Change only the 3 lines it mentions in the video, I believe it’s 42-44, then save. Do NOT run the program, just go back to your list and try it out. Doing it that way has worked so far, no errors or glitches. Also - Apps Script was found under Extensions, not Tools for me.

[@MisoMooncake]

Yep! It worked. Thanks for the tip.

[@herjeens1031]

YES!! Thank you =)

[@ameliecheplo4585]

Thank you, because this ended up working for me as well!

[@grahampclark03]

Awesome video and so helpful! Thank you!

[@jayharrisonnz]

Script wasn't working for me either. Changed row 68 and 73 from 0 to 1 and now its working again.

[@russcharif4320]

Excellent-- thank you!

[@ProlificOaktree]

You're very welcome!

[@vincentianpenaflor5842]

how about to sort rows with cells in greens on top and cells in red below

[@ecenari]

I cannot find script editor in my google sheet under tools. only under apps aps and Appscript

[@_ValFreemaN_]

awesome video thank you!

[@PrincesCatherineSomera]

Thank you!!! It helps!!

[@ProlificOaktree]

🔥

[@alaynealexander9218]

I have mine all set, except when I check the box, it goes to row 13 every time instead of the bottom of the list. Help?

[@Daisy-3.0]

I could not get this to work for anything. After several hours, I gave up and went looking elsewhere.

[@ProlificOaktree]

But think of how much you learned in the process;)

[@Daisy-3.0]

​@@ProlificOaktreeI learned nothing. I still don't have a self sorting list. Just gave up and used Google Keep, which doesn't resolve all I needed, but does most of it.

[@herjeens1031]

I can do the auto sort but if I mark something complete by accident and uncheck to mark incomplete again, the box still remains at the bottom of the list instead of filtering back to the top. can anyone help? =) Thanks!!

[@chloewilliams1702]

I'm not sure how to have it go back up automatically, but when this happens to me I just press the undo button twice (quickly) to undo the automated action and my accidinetal checking of the box.

[@klwin1123]

Thanks a lot 🙏. It helps

[@ProlificOaktree]

Happy to help

[@jayteague401]

Great voice!

[@Ketch22k]

How can you add due dates and to prioritize it?

[@chloewilliams1702]

That gets a bit more comlicated tbh. You'll need the conditional formating section again. Make another conditional format for the column you want your due date in. Select the range (I always just input down to 500 or something ridiculous so that I have room), and you'll put the formula "=D2

[@rebekahjames2310]

How is it that so many people are having the same error and no one is addressing it? It is super frustrating. No one can help on here or on git hub.

[@omdcosta2331]

No experience with JS or anything, but was messing around trying to solve the issue of undefined range at Line 63. Finally found a solution which makes script workable for me. Try replacing lines 61-64 of script with text below: function autoSort(sheet) { // Get the entire set of data for this sheet. var sheet=SpreadsheetApp.getActiveSpreadsheet(); var range = sheet.getDataRange();

[@charliebunde]

Because the doorknob won't fix the problem and tell us

[@sparklypenguin9313]

@@omdcosta2331 this worked for me!!! thank you so much.

[@MarkAnthonyVido]

error at line 63 - TypeError: Cannot Read properties of undefined (reading 'getDataRange')

[@ProlificOaktree]

Sorry you're having the error. I think it's been discussed in the comments quite a bit. Please have a look through them. Best of luck!

[@bradleycurry2896]

I am trying this really neet Apps Script but I am getting the following error when I Run the Script: 12:23:09 PM Error TypeError: Cannot Read property 'getDataRange' of undefined autoSort @ Code.gs:63 What Can I do to fix this issue?

[@ProlificOaktree]

I kept getting that too. Did you run it from inside the editor and then give it permissions when it asked?

[@bradleycurry2896]

@@ProlificOaktree Yes, I followed your video 100%? Any suggestions?

[@bradleycurry2896]

@@ProlificOaktree If this comes to you twice, I am sorry, Yes, I followed your video, I believe 100%? Do you have any suggestions. I have to admit I am a novice with this process.

[@ProlificOaktree]

I would suggest going to the linked GitHub page. There is a lot of discussion there. Let us know if you solve it.

[@bradleycurry2896]

@@ProlificOaktree Thank you, your Channel is Fantastic...I have learned a lot from watching them...

[@nimzek]

you're wrong, the custom formula in your case is =$A2 (and not =A2=TRUE).

[@ProlificOaktree]

Yeah, seems like we can get rid of the =TRUE part. The & isn't necessary though, but doesn't hurt. Perhaps the best option is =A2