Google Sheets - Add Timestamp When Cell Changes - Apps Script
Learn how to create a script to add a timestamp when cell is updated in Google Sheets.
Жүктеу.....
Пікірлер: 776
@scott-ish4043 жыл бұрын
I love the way you explain everything by stages, without delving into too much technicalities and even makes the improvements on it easy to grasp, so that even a code-ignorant like me can follow it easily. Subscribing to your channel in 3, 2, 1...!
@kickinitwithk7463 жыл бұрын
I searched for hours for this solution! Your teaching methods were clear and easy to follow. Thank you.
@lucazarts25 Жыл бұрын
I think anyone could learn how to code with a professor like you. Congratulations and thank you for the knowledge shared!
@BustaCap3 жыл бұрын
I’ve learned so much from this channel it’s insane. Thanks for all your help.
@teresalgeorge3 жыл бұрын
I searched and searched and SEARCHED to find the code for this EXACT thing! I simply cannot tell you HOW MUCH I appreciate you doing this VIDEO!!! I have spent endless hours to try to get this to work and could not get it! AMAZING and THANK YOU SO MUCH FOR HELPING MY SANITY! :)
@philippschumacher46594 жыл бұрын
Thank you very much. After watching a lot of videos regarding this, i finally found yours and understood what i did. Not just copy and paste code.
@JanRossi3 жыл бұрын
Totally just used this. Thank you. I feel like I kinda jumped into the advanced area. but you made it easy to follow your instructions. Thank you!
@manasgarg144 жыл бұрын
This is exactly what I'm looking for, thanks for the tutorial. Great job man! THANKS A TON !!! :)
@affiqfadzil4 жыл бұрын
Great job! Clear tutorial, exactly what i'm looking for.. Thank you so much
@LucasFurioFranco4 жыл бұрын
I freaking love you, man! Thanks for the lesson, it works wonders! S2 Thank you, thank you a lot! I can't express how grateful I am to you right now! Best regards!
@teresalgeorge
3 жыл бұрын
ME TOO!! I AM just so THANKFUL for this video ! lol I LOVE THIS MAN FOR DOING THIS!
@hoiyinwan82334 жыл бұрын
That was amazing tutorial, thank you for making this.
@Brakken993 жыл бұрын
I had an issue as many have with the ranged error. Two things - an error will be returned if you run the code from the editor OR debugger. The reason for this is the conditions of the fields are not being met on the spreadsheet side and this is normal. The other thing is recheck ALL OF YOUR SYNTAX. I chased this problem for far longer than I should have and found I had typed a "v" where a "u" should have gone in value - was too easy to miss but it looked right at a glance. Once this correction was made the code started to function correctly. Another great video by this youtuber!
@gladysgalat4992
Жыл бұрын
Hello, I had a problem with the range. What could possibly be the error? Thank you so much!
@nasirshaikh27154 жыл бұрын
I really appreciate the video which you have made, it is very easier for the non-technical person to understand, thank you so much. I am the new person who is going to use this script in our master sheet and also I would like to see more videos to learn the same from scratch... :)
@omarjimz4 жыл бұрын
Awesome. Not only learned to timestamp but scripting in Google Sheets. Thanks!
@whinapomana97154 жыл бұрын
This is such a great tutorial, thank you so much!
@RadoHudran17 күн бұрын
I remember following this 2 years ago took me easily 3 hours or so and I got a headache. It felt like a huge achievement to complete it. Now I made this code for a new sheet and it took me 30 min, felt easy, but most importantly,; this video has proven valueable over and over. I use this code in a sheet I use weekly and it has saved me lots of time. Thanks a bunch!
@GoTouchSomeGrassBuddy2 ай бұрын
You just taught EXACTLY what I'm searching for! Thank you!!! You explain everything clearly!
@davem453 жыл бұрын
I am so glad I stumbled on your channel this is perfect. now I have to figure out that when our receptionist receives a package, based on the tracking number it will fill in the carrier in cell 3 Thanks so much for this tutorial
@garricko4 жыл бұрын
Thank you for making this! This helped a lot with my simple spreadsheet.
@wagnerbarbosa18942 жыл бұрын
Speaking from Brasil! Simply perfect! Thank you!
@Nibarger Жыл бұрын
Very nice...I've been watching many others and you are by far the easiest to follow and understand. Thank you very much.
@subratadutta45624 жыл бұрын
Nicely explained with minute details. Thanks for uploading this video. Looking forward to watch more.
@najmuddinazik4 жыл бұрын
Thank you so much. I follow step by step and make it! God bless you for helping🙏🏼☺️
@unityindualities4 жыл бұрын
Thank you so much for doing this, I love this page so much. You are contributing to something that is going to change the world, and I can't thank you enough. Thank you for all these tutorials, they have helped me insurmountably.
@StarsNStripesForever2 жыл бұрын
Super helpful. Thanks for the run-through!
@prony51453 жыл бұрын
Great!! I have just been looking for this everywhere. Thanks a lot man.
@faktadantipsunik4 жыл бұрын
You're doing a great job. Thank you...
@carloumali34173 жыл бұрын
great tutorial, easy to understand! I tried it myself and it works!
@sinisamoravac84823 жыл бұрын
Works perfectly for me! Very well explained!! Thank you
@audiomemento Жыл бұрын
Wow I finally got this to work thanks to your video! Super helpful and well explained.
@kamleshpatel82443 жыл бұрын
Amazingly helpful video, very easy to follow and give confidence adapt too ... thank you so much
@apljaaay3 жыл бұрын
THANK YOU FOR SHARING YOUR KNOWLEDGE MAN!!
@osamachoudary43794 жыл бұрын
Thank you very much, this is an amazing tutorial. Learned soo much from it. Thumbs up (Y)
@edisonpalima4 жыл бұрын
Thank you very much. This is the exact tutorial that I'm looking for. I'm now subscribed :)
@ExcelGoogleSheets
4 жыл бұрын
Thanks for the sub!
@tamayonoelle883 жыл бұрын
Very informative and superb knowledge! Thank you for sharing it!
@jamessteffen47054 жыл бұрын
Thank you, super helpful. Great Job!!!
@jogifrh2 жыл бұрын
Simple and useful tutorial! Thanks.
@stephenmatheny99334 жыл бұрын
You're the best man, thank you!!
@kunal_chand3 жыл бұрын
Helpful as always. Brilliant!
@ohwe0w2263 жыл бұрын
Thank you!! No coding experience whatsoever and I was able to do it!
@ExcelGoogleSheets
3 жыл бұрын
Excellent!
@lovelyktott3 жыл бұрын
i really appreciate and do love everything you teach. It's so simple and easy to use in real work. I practice and really use it in my restaurant. I would like to thank you for all these knowledge. If you come to Thailand, let me know, I will guide you around enjoy Bangkok for 1 day....Thankssssssssssss my real teacher
@RadoHudran2 жыл бұрын
Awesome, I enjoyed coding with you because it's interesting and I can't code on my own at all. Thx!
@anvarnazar65453 жыл бұрын
Thanks a ton for this tut. Saved my day
@dannybans234 жыл бұрын
Thank you so much, brother! This is exactly the solution I was looking for! I was experimenting with circular reference formulas, but the date would update the following day after inputting content into adjacent cells. So I needed a different solution. I thought of using some sort of script and just searched KZread. Thank goodness I found your video! You saved me so much time! Well done, great work! - Greeting from Toronto, Canada!
@ExcelGoogleSheets
4 жыл бұрын
Glad it helped!
@soamyaashishgetengaged7881
4 жыл бұрын
@@ExcelGoogleSheets This only works when the owner of the sheet makes any change but if anyone enter any value then the timestamp doesnot appear. I want to create the same when anyone can enter the value
@subhamdey1922
2 жыл бұрын
@@ExcelGoogleSheets Can you help me with the script code?
@ali399
Жыл бұрын
@@subhamdey1922 Code.gs function onEdit(e) { addTimestamp (e); } function addTimestamp (e){ //variables I 7 R 7/16:38 Fix Date Delay > var startRow 2; = var targetColumn = 1; var ws = "My Data"; //get modified row and column var row = e. .range.getRow(); var col = e.range.getColumn(); if (col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() WS var currentDate = new Date(); e.source.getActiveSheet().getRange (row, 4).setValue(currentDate); if (e.source.getActiveSheet().getRange (row, 3).getValue() ""){ e.source.getActiveSheet().getRange (row, 3).setValue(currentDate); } // END IF check if date created exists } // END IF check column, row, worksheet
@PencilBoxID4 жыл бұрын
This exactly what im looking for, thanks for the tutorial,
@manishdashsharma7381
4 жыл бұрын
Hello you know app scripting?
@Azraelsky14 жыл бұрын
I have no words... Thank you so much!
@travel247peru84 жыл бұрын
Congratulations ! i not speak well english, but you explain very easy and simple , thanks for your work , definettly best tutorial ever ! hugs from Perú
@hellboy14882 жыл бұрын
this was very helpful and my very first exposure to any sort of code! worked perfectly thank you!
@EnriqueGonzalezOrtiz4 жыл бұрын
Really interesting. Thanks so much!!
@saoudiabdealbaseete42393 жыл бұрын
Dude, you're the best, I wish you get everything that you want my friend
@dennyandriansyah25603 жыл бұрын
exactly what I looking for.. thanks for tutorial.. very helpful..
@CompSciSimplified2 жыл бұрын
Thanks man,respect for your hard work.
@xGSTQ4 жыл бұрын
Thanks for this, trying to learn Apps Script :)
@johnglover35154 жыл бұрын
Thanks so much this was an awesome well worded easy to follow tutorial. A+++
@lumberdesign44014 жыл бұрын
Very Helpful Tutorial!
@bangdoeltips74923 жыл бұрын
Very useful and helpful tutorial, thank you.
@Xansos2 жыл бұрын
Thanks a lot for this man, exactly what i was looking for
@RebelPrinceTrys4 жыл бұрын
This really worked-- thank you so much!!!!!!!
@eptrade23234 жыл бұрын
This is quite amazing! I found a different way of doing it, it is simple, but works for me. I created a "form" with google forms..... as a question you can ask: what is the package id? and let the response be text (the id)... once the answer is submitted you can ask google forms to send the results to a google spreadsheet..... the time stamp is a default column.
@emmanuelmgbemena3 жыл бұрын
You are the best. You just helped me. Beautiful explanation
@bhawanishekhawat31634 жыл бұрын
Very nice video and it is very useful in companies where Google sheets are used too much, our company is completely on Gmail
@cristinapajarillo69562 ай бұрын
Thanks so much you helped improve my project significantly! All the best!
@KuroNoSatsujin4 жыл бұрын
Awesome, man! Regards from Brazil
@mailtossundar Жыл бұрын
the way of writing codes and explanations is easily understandable to everyone thanks for this video.
@k2s3532 жыл бұрын
Thanks for that great explanation!
@49findus4 жыл бұрын
Very good tutorial! Thank you :)
@francoisdupreez60744 жыл бұрын
Very helpful thanks a million!!
@drylunch84623 жыл бұрын
Really useful info, thank you very much for posting, have now subscribed
@dennis.teevee4 жыл бұрын
You're awesome! Thank you!
@guyw6849 Жыл бұрын
There have been a few questions on how to run the same script on more than one sheet, but not all of them. Through simple copy and paste, I quickly created multiple scripts, one for each sheet I wanted the script to run on, giving each a unique name (e.g., Script1, Script2, Script3. - I gave mine the name of the sheet they corresponded to). Note, you can only have one script named "onEdit." You will want to reserve the onEdit name for the short "master script" that will run the rest. After creating each new script, copy and paste the same code into each. Then, change the script name on the first line of code (right after "function" and before "(e)" to match the name of the new script. Then, change the sheet reference in the code located right after "getName() ===" to match the name of the sheet that script should run on. Finally, go back to your original onEdit script and delete all of the code and paste the following new code, making the onEdit script the "master script" to run the rest of them (of course, modify the script names to match your script names, adding however many scripts you have): function onEdit(e) { script1(e); script2(e); script3(e); } Remember to save the scripts. While on the onEdit master script, click "Run." The sheet-specific scripts will execute in the order they appear in your onEdit master script. I have no coding skills. But after some research, this approach worked for me.
@RadoHudran
Жыл бұрын
You might want to check this guy's vid at 3:30 kzread.info/dash/bejne/gGiKkqiTcbaxZpM.html He talks about the "OR" statement and how you can use it This will make your code a lot shorter and quicker to execute. I also got no coding knowledge but trust me it's easy EDIT: It's not very easy tho For it to work properly my if statement had to be: if(col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() === ws ||col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() === bs){ bs stands for bullsh!t as well as var bs = Sheet 2 I had to repeat almost the entire statement inside IF() So in theory you could expand this row infinitely for as many sheets as you want In the end it works, even though it's not as compact as I'd like
@anjanamihiran86654 жыл бұрын
This is such a great tutorial.
@muraly35232 жыл бұрын
Thank you very much.You are a very good teacher.
@patrickstenger23163 жыл бұрын
Thank You so much. very well explained. and useful.
@Mikarevival4 жыл бұрын
Great Job!! Thanks!
@aunga.82184 жыл бұрын
Thank a lot. This video save my time
@RonMorlan151610 ай бұрын
Just did a mod of this code and it worked great! Thanks for a great tutorial!
@mostafizurrahman41103 жыл бұрын
Thank you so much brother for your helpful video.
@benedictchua-theredreamer Жыл бұрын
love the way you explain the script , not just typing it. for begginers like me, looking for some code for my project, thanks
@ExcelGoogleSheets
Жыл бұрын
👍
@vivienm57193 жыл бұрын
Such great explanation and helpful information. Thanks!
@ExcelGoogleSheets
3 жыл бұрын
Glad it was helpful!
@cryptowannabenoob4 жыл бұрын
nice, learned a lot, thanks buddy.
@DavidMacKayE3 жыл бұрын
Holy Smokes, I think I found my new teacher. Wow!!
@administradordrycleanservi5321 Жыл бұрын
Apreciated the good explanation, keep it up!
@kyledinwiddie99622 жыл бұрын
Fabulous tutorial. Thank you
@anurajms3 жыл бұрын
thank you. its really helpful
@user-zw6bw3kt7j Жыл бұрын
thank you for sharing, all your tutorial very very very very helpful. God Bless you and Family always
@SergiuPoenaru2 жыл бұрын
Thanks, man, you're awesome!
@juansebastianlopez44474 жыл бұрын
many thanks for share ur knowledge
@AndyMcProducer2 жыл бұрын
Great easy to understand video, def subbing.
@ExcelGoogleSheets
2 жыл бұрын
Thanks for the sub!
@indopark3434 жыл бұрын
thank you its very helpful
@agamgumelar6605 Жыл бұрын
Works like a charm, thank you so much bro!!
@ExcelGoogleSheets
Жыл бұрын
👍
@vaibhavkhaire70143 жыл бұрын
Awesome. Thank you so much
@atluu43713 жыл бұрын
I love it. Thank you
@norma-bh4vo13 күн бұрын
SO HELPFUL THANK YOU!
@davidchoi3869 Жыл бұрын
U R A GOD to me Right now absolute Awesomeness & Happy Thoughts Thank U So Much!!!
@gebruikerarjan4 жыл бұрын
Great tut! Could you drop the script in the description below of your video? then you just can copy paste it. That would be easy!
@aimeemabunga2747 Жыл бұрын
Thanks so much for this!
@benjaminalonso46304 жыл бұрын
muchas gracias, ya tenía un modelo de script en GAS, para hacer funcionar registros de modificación, me andaban bien, hasta que la hoja tuvo que albergar a varios agentes haciendo modificaciones, espero que ahora con esta forma de registro, pueda funciona, probaré ahora mismo en mi hoja, muchas gracias por ayudarme a simplificar !!!
@Corigador4 жыл бұрын
Great instructions! Thanks. Is there a way to make the timestamp trigger when you paste several rows of data into the target column? Currently it only adds the timestamp to the top line where the start of the list was pasted.
Пікірлер: 776
I love the way you explain everything by stages, without delving into too much technicalities and even makes the improvements on it easy to grasp, so that even a code-ignorant like me can follow it easily. Subscribing to your channel in 3, 2, 1...!
I searched for hours for this solution! Your teaching methods were clear and easy to follow. Thank you.
I think anyone could learn how to code with a professor like you. Congratulations and thank you for the knowledge shared!
I’ve learned so much from this channel it’s insane. Thanks for all your help.
I searched and searched and SEARCHED to find the code for this EXACT thing! I simply cannot tell you HOW MUCH I appreciate you doing this VIDEO!!! I have spent endless hours to try to get this to work and could not get it! AMAZING and THANK YOU SO MUCH FOR HELPING MY SANITY! :)
Thank you very much. After watching a lot of videos regarding this, i finally found yours and understood what i did. Not just copy and paste code.
Totally just used this. Thank you. I feel like I kinda jumped into the advanced area. but you made it easy to follow your instructions. Thank you!
This is exactly what I'm looking for, thanks for the tutorial. Great job man! THANKS A TON !!! :)
Great job! Clear tutorial, exactly what i'm looking for.. Thank you so much
I freaking love you, man! Thanks for the lesson, it works wonders! S2 Thank you, thank you a lot! I can't express how grateful I am to you right now! Best regards!
@teresalgeorge
3 жыл бұрын
ME TOO!! I AM just so THANKFUL for this video ! lol I LOVE THIS MAN FOR DOING THIS!
That was amazing tutorial, thank you for making this.
I had an issue as many have with the ranged error. Two things - an error will be returned if you run the code from the editor OR debugger. The reason for this is the conditions of the fields are not being met on the spreadsheet side and this is normal. The other thing is recheck ALL OF YOUR SYNTAX. I chased this problem for far longer than I should have and found I had typed a "v" where a "u" should have gone in value - was too easy to miss but it looked right at a glance. Once this correction was made the code started to function correctly. Another great video by this youtuber!
@gladysgalat4992
Жыл бұрын
Hello, I had a problem with the range. What could possibly be the error? Thank you so much!
I really appreciate the video which you have made, it is very easier for the non-technical person to understand, thank you so much. I am the new person who is going to use this script in our master sheet and also I would like to see more videos to learn the same from scratch... :)
Awesome. Not only learned to timestamp but scripting in Google Sheets. Thanks!
This is such a great tutorial, thank you so much!
I remember following this 2 years ago took me easily 3 hours or so and I got a headache. It felt like a huge achievement to complete it. Now I made this code for a new sheet and it took me 30 min, felt easy, but most importantly,; this video has proven valueable over and over. I use this code in a sheet I use weekly and it has saved me lots of time. Thanks a bunch!
You just taught EXACTLY what I'm searching for! Thank you!!! You explain everything clearly!
I am so glad I stumbled on your channel this is perfect. now I have to figure out that when our receptionist receives a package, based on the tracking number it will fill in the carrier in cell 3 Thanks so much for this tutorial
Thank you for making this! This helped a lot with my simple spreadsheet.
Speaking from Brasil! Simply perfect! Thank you!
Very nice...I've been watching many others and you are by far the easiest to follow and understand. Thank you very much.
Nicely explained with minute details. Thanks for uploading this video. Looking forward to watch more.
Thank you so much. I follow step by step and make it! God bless you for helping🙏🏼☺️
Thank you so much for doing this, I love this page so much. You are contributing to something that is going to change the world, and I can't thank you enough. Thank you for all these tutorials, they have helped me insurmountably.
Super helpful. Thanks for the run-through!
Great!! I have just been looking for this everywhere. Thanks a lot man.
You're doing a great job. Thank you...
great tutorial, easy to understand! I tried it myself and it works!
Works perfectly for me! Very well explained!! Thank you
Wow I finally got this to work thanks to your video! Super helpful and well explained.
Amazingly helpful video, very easy to follow and give confidence adapt too ... thank you so much
THANK YOU FOR SHARING YOUR KNOWLEDGE MAN!!
Thank you very much, this is an amazing tutorial. Learned soo much from it. Thumbs up (Y)
Thank you very much. This is the exact tutorial that I'm looking for. I'm now subscribed :)
@ExcelGoogleSheets
4 жыл бұрын
Thanks for the sub!
Very informative and superb knowledge! Thank you for sharing it!
Thank you, super helpful. Great Job!!!
Simple and useful tutorial! Thanks.
You're the best man, thank you!!
Helpful as always. Brilliant!
Thank you!! No coding experience whatsoever and I was able to do it!
@ExcelGoogleSheets
3 жыл бұрын
Excellent!
i really appreciate and do love everything you teach. It's so simple and easy to use in real work. I practice and really use it in my restaurant. I would like to thank you for all these knowledge. If you come to Thailand, let me know, I will guide you around enjoy Bangkok for 1 day....Thankssssssssssss my real teacher
Awesome, I enjoyed coding with you because it's interesting and I can't code on my own at all. Thx!
Thanks a ton for this tut. Saved my day
Thank you so much, brother! This is exactly the solution I was looking for! I was experimenting with circular reference formulas, but the date would update the following day after inputting content into adjacent cells. So I needed a different solution. I thought of using some sort of script and just searched KZread. Thank goodness I found your video! You saved me so much time! Well done, great work! - Greeting from Toronto, Canada!
@ExcelGoogleSheets
4 жыл бұрын
Glad it helped!
@soamyaashishgetengaged7881
4 жыл бұрын
@@ExcelGoogleSheets This only works when the owner of the sheet makes any change but if anyone enter any value then the timestamp doesnot appear. I want to create the same when anyone can enter the value
@subhamdey1922
2 жыл бұрын
@@ExcelGoogleSheets Can you help me with the script code?
@ali399
Жыл бұрын
@@subhamdey1922 Code.gs function onEdit(e) { addTimestamp (e); } function addTimestamp (e){ //variables I 7 R 7/16:38 Fix Date Delay > var startRow 2; = var targetColumn = 1; var ws = "My Data"; //get modified row and column var row = e. .range.getRow(); var col = e.range.getColumn(); if (col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() WS var currentDate = new Date(); e.source.getActiveSheet().getRange (row, 4).setValue(currentDate); if (e.source.getActiveSheet().getRange (row, 3).getValue() ""){ e.source.getActiveSheet().getRange (row, 3).setValue(currentDate); } // END IF check if date created exists } // END IF check column, row, worksheet
This exactly what im looking for, thanks for the tutorial,
@manishdashsharma7381
4 жыл бұрын
Hello you know app scripting?
I have no words... Thank you so much!
Congratulations ! i not speak well english, but you explain very easy and simple , thanks for your work , definettly best tutorial ever ! hugs from Perú
this was very helpful and my very first exposure to any sort of code! worked perfectly thank you!
Really interesting. Thanks so much!!
Dude, you're the best, I wish you get everything that you want my friend
exactly what I looking for.. thanks for tutorial.. very helpful..
Thanks man,respect for your hard work.
Thanks for this, trying to learn Apps Script :)
Thanks so much this was an awesome well worded easy to follow tutorial. A+++
Very Helpful Tutorial!
Very useful and helpful tutorial, thank you.
Thanks a lot for this man, exactly what i was looking for
This really worked-- thank you so much!!!!!!!
This is quite amazing! I found a different way of doing it, it is simple, but works for me. I created a "form" with google forms..... as a question you can ask: what is the package id? and let the response be text (the id)... once the answer is submitted you can ask google forms to send the results to a google spreadsheet..... the time stamp is a default column.
You are the best. You just helped me. Beautiful explanation
Very nice video and it is very useful in companies where Google sheets are used too much, our company is completely on Gmail
Thanks so much you helped improve my project significantly! All the best!
Awesome, man! Regards from Brazil
the way of writing codes and explanations is easily understandable to everyone thanks for this video.
Thanks for that great explanation!
Very good tutorial! Thank you :)
Very helpful thanks a million!!
Really useful info, thank you very much for posting, have now subscribed
You're awesome! Thank you!
There have been a few questions on how to run the same script on more than one sheet, but not all of them. Through simple copy and paste, I quickly created multiple scripts, one for each sheet I wanted the script to run on, giving each a unique name (e.g., Script1, Script2, Script3. - I gave mine the name of the sheet they corresponded to). Note, you can only have one script named "onEdit." You will want to reserve the onEdit name for the short "master script" that will run the rest. After creating each new script, copy and paste the same code into each. Then, change the script name on the first line of code (right after "function" and before "(e)" to match the name of the new script. Then, change the sheet reference in the code located right after "getName() ===" to match the name of the sheet that script should run on. Finally, go back to your original onEdit script and delete all of the code and paste the following new code, making the onEdit script the "master script" to run the rest of them (of course, modify the script names to match your script names, adding however many scripts you have): function onEdit(e) { script1(e); script2(e); script3(e); } Remember to save the scripts. While on the onEdit master script, click "Run." The sheet-specific scripts will execute in the order they appear in your onEdit master script. I have no coding skills. But after some research, this approach worked for me.
@RadoHudran
Жыл бұрын
You might want to check this guy's vid at 3:30 kzread.info/dash/bejne/gGiKkqiTcbaxZpM.html He talks about the "OR" statement and how you can use it This will make your code a lot shorter and quicker to execute. I also got no coding knowledge but trust me it's easy EDIT: It's not very easy tho For it to work properly my if statement had to be: if(col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() === ws ||col === targetColumn && row >= startRow && e.source.getActiveSheet().getName() === bs){ bs stands for bullsh!t as well as var bs = Sheet 2 I had to repeat almost the entire statement inside IF() So in theory you could expand this row infinitely for as many sheets as you want In the end it works, even though it's not as compact as I'd like
This is such a great tutorial.
Thank you very much.You are a very good teacher.
Thank You so much. very well explained. and useful.
Great Job!! Thanks!
Thank a lot. This video save my time
Just did a mod of this code and it worked great! Thanks for a great tutorial!
Thank you so much brother for your helpful video.
love the way you explain the script , not just typing it. for begginers like me, looking for some code for my project, thanks
@ExcelGoogleSheets
Жыл бұрын
👍
Such great explanation and helpful information. Thanks!
@ExcelGoogleSheets
3 жыл бұрын
Glad it was helpful!
nice, learned a lot, thanks buddy.
Holy Smokes, I think I found my new teacher. Wow!!
Apreciated the good explanation, keep it up!
Fabulous tutorial. Thank you
thank you. its really helpful
thank you for sharing, all your tutorial very very very very helpful. God Bless you and Family always
Thanks, man, you're awesome!
many thanks for share ur knowledge
Great easy to understand video, def subbing.
@ExcelGoogleSheets
2 жыл бұрын
Thanks for the sub!
thank you its very helpful
Works like a charm, thank you so much bro!!
@ExcelGoogleSheets
Жыл бұрын
👍
Awesome. Thank you so much
I love it. Thank you
SO HELPFUL THANK YOU!
U R A GOD to me Right now absolute Awesomeness & Happy Thoughts Thank U So Much!!!
Great tut! Could you drop the script in the description below of your video? then you just can copy paste it. That would be easy!
Thanks so much for this!
muchas gracias, ya tenía un modelo de script en GAS, para hacer funcionar registros de modificación, me andaban bien, hasta que la hoja tuvo que albergar a varios agentes haciendo modificaciones, espero que ahora con esta forma de registro, pueda funciona, probaré ahora mismo en mi hoja, muchas gracias por ayudarme a simplificar !!!
Great instructions! Thanks. Is there a way to make the timestamp trigger when you paste several rows of data into the target column? Currently it only adds the timestamp to the top line where the start of the list was pasted.
AWESOME!!!!! Thank you so much!
It helping a lot, thank you