tag:blogger.com,1999:blog-6799428426680372912.post1190267611267140091..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Google Spreadsheet Script to Auto Sort Range after modifyingKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6799428426680372912.post-69777450662664423722017-04-25T13:34:33.437+05:302017-04-25T13:34:33.437+05:30Working perfectly, tnxWorking perfectly, tnxRagnarhttps://www.blogger.com/profile/11667105252759505659noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-45308563859067689092016-05-02T21:24:01.488+05:302016-05-02T21:24:01.488+05:30Hi You have the only auto-sort script that has wor...Hi You have the only auto-sort script that has worked for me - thank you for your help! It's working great, only I can't figur eout how to sort for multiple ranges at once. In other words, I'm trying to auto sort four sets of data based on edit. Any ideas how to get that to function correctly using the script editor?Anonymoushttps://www.blogger.com/profile/15922054579240523132noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-89855769732630052662016-01-07T00:48:56.050+05:302016-01-07T00:48:56.050+05:30Nevermind, I figured the answer. I used:
functio...Nevermind, I figured the answer. I used:<br /><br /><br />function onEdit(e) {<br /> var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");<br /> sheet.sort(7, true);<br />}<br /><br /><br />where "7" is Column G. I sorted Column B so changed it to "2" My sheet is named "Sheet 1" by default but you would change it to whatever yours isSplinterhttps://www.blogger.com/profile/00055726845320473726noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-59013298472192942922016-01-07T00:15:58.448+05:302016-01-07T00:15:58.448+05:30I have basically the same question as the two abov...I have basically the same question as the two above posters... I'd like to have my columns sorted without being shifted to the bottom of my anticipated range. Thanks in advance for any help you can give me!Splinterhttps://www.blogger.com/profile/00055726845320473726noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-50896667150588665932015-10-23T21:44:33.889+05:302015-10-23T21:44:33.889+05:30I am working on a document that I need to have aut...I am working on a document that I need to have auto sorted every time a new date is entered. Row 1 A-F are the column headers (F being the date column)<br /><br />Every time a new date is entered into column F (along with the accompanying information from A-E columns) needs to be sorted according to the most recent date.<br /><br />Is there any way you can help me? I have been poking around withAnonymoushttps://www.blogger.com/profile/06460751525164423206noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-72468589059752453802015-09-11T13:33:16.411+05:302015-09-11T13:33:16.411+05:30How do you increase the range so that the script t...How do you increase the range so that the script takes into account for future info, like i need all 1000 rows to be included without all my current data being shifted to the bottom every time i add something in the next row, my current data set goes from A2 to C27 but if i add something in row 28 nothing happens, unless i change the script each time to include the next row. If i make the range Anonymoushttps://www.blogger.com/profile/16704088897017970052noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-38545755548844779962013-08-20T00:45:47.989+05:302013-08-20T00:45:47.989+05:30Wow Kishan, looks great. I'll let you know how...Wow Kishan, looks great. I'll let you know how stuff ends in my sheets ;)<br />Herman Fhttps://www.blogger.com/profile/16479919885349780002noreply@blogger.com