google sheets timestamp This is a topic that many people are looking for. bluevelvetrestaurant.com is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, bluevelvetrestaurant.com would like to introduce to you How to add a Timestamp (time stamp) in Google Docs Spreadsheet – The easy way. Following along are instructions in the video below:
“There youtube. People what i m gonna do for you in this video is i i m gonna show you how to add a timestamp in google docs spreadsheet in same way that you can in excel. It s not as easy as it is in excel. But it is doable you just need to know what you re doing i figured this out after swirling through a lot of forms of people saying that you need to be write in code to do it or these very complicated work workarounds and but it actually turned out to be quite simple if you know where to look so it s dead easy what i wanted to do is i want when this spreadsheet that i ve set up.
Which is just a tracking spreadsheet. When this changes from no ts. I want a date to appear in this box. Here.
I ve actually set it up with a couple of errors that are going to happen when i do this to show you how to work around them as well it s going to go wrong at first and i ll show you how to fix that so first things first. I need to install a script to allow the timestamp to work so you do that by clicking on tools going to script gallery. So it s a gallery to someone else as well. It s a script that someone s already put together and put in the gallery.
If you just scroll down a bit you re looking for the one that s called last updated which is this one right here and you just click on install now this will take just a second there we go you have to authorize it to mean that it can change your spreadsheet. Which is what i wanted to do and there we go that s now authorized to close that and bausch were away so i m now gonna close. The script gallery this will now work. I ve installed it it s all about just getting it to go where i want it to go so now.
If i change this here to yes this means a students achieved they ve updated that i press enter. I m gonna get a date it goes here now that is in the wrong place..
I want it in this box. So i now need to make a little change to my spreadsheet to get that to work. So i ll just undo that okay so well it s going this one it goes in the last column in the last cell of the last column in your spreadsheet. So it s going to go here.
When i tell it that this is the last one now what i m gonna do is i m gonna type in date assess in this box. But because this is now the last column as soon as i change this it s going to change it to a day which is why i ve left this in because it s i m gonna show you how you can edit a cell and then if you don t want the date to come up you can just make it go away so i m gonna press enter there s the date. I don t want the date. I want they assess to show up so ctrl s on the keyboard know so it ctrl and said on the keyboard undoes that and the last step is to add the date so it just undoes that everything else stays the same so that s beautiful that s what i wanted okay so now.
When i type in yes into this box. Here oops that didn t work wait..
Am. I why go yes. There we go and my date appears in this box here now at the moment. I can t reformat this because whoever wrote the script let s put it so there s a little apostrophe at the beginning.
I m sure that s useful for some reason. I don t know why it s not useful for me so i m going to remove that so i can reformat the date. And there is already some formatting on this cell. So it will change it as soon as i get that right so to edit the script you need to just click on tools again and then you re going to go to the script manager which allows you to manage any of the scripts that are currently running on your spreadsheet.
So i ve got this on edit one that just installed so i m going to click on edit and it s a very very quick update i know nothing about script and i found this in about 5 seconds. If you just look at the bottom here last sell set value..
It s actually telling it here to add an apostrophe then the date well i don t want the apostrophe so i m gonna delete that and then file save ok that i ll now save that script i can close it and now when i update this cell again so i m gonna go back to no. And it won t change because i ve done an update. They all go july. The night for 2012 bosch and that s all there is to it if you want to move the date around there are obviously lots of different workouts or it.
But generally if you want this to work simply plan to have your timestamp in whichever is the last cell on your last column and it ll be dead straightforward i hope you found this useful feel free to like comment subscribe. But more importantly share this to other people that don t know because it took me a couple of days to work this whereas. If this video had been around would have taken me minutes thanks for ” ..
Thank you for watching all the articles on the topic How to add a Timestamp (time stamp) in Google Docs Spreadsheet – The easy way. All shares of bluevelvetrestaurant.com are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.