How To Timestamp Cells In Google Sheets

Подписаться 35 тыс.

Просмотров 97 тыс.

50% 1

How To Timestamp Cells In Google Sheets
📈 Link to download all my Portfolio Trackers: / thinkstocks
🌎 Follow me on Twitter: / keithfrislid
🎥 Here is the camera I use for my videos: amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
www.sahg6dtr.com/28KL61/R74QP/
In this video, I will show you the easiest way to timestamp a cell in google sheets. It took me a while to figure out this one but it is rather simple and only a couple of letters and numbers in a function.
This function will not only timestamp the date of a cell but is also can timestamp the time down to the second! This can be very helpful if you are looking to keep track of stocks you are buying and selling, leads you are following up on, or entries being made.
There are plenty of other videos out there that will get into advanced coding to timestamp a cell but it doesn't need to be that hard! Hope you enjoy the video and learn something from it, and make sure to smash that like button, subscribe to my channel and hit that share button so more people can learn about this neat little function!
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#timestampcells #googlesheets #googlesheetsfunctions #googlesheetshacks

Опубликовано:

14 дек 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 152

@thyrosetabra8182 11 месяцев назад

Thanks a TON! I've been looking around for formula in making live timestamp and this one is so far the best and straightforward one I got!

@Longliveicecream 3 года назад

Thank you! Was watching another video and it was putting a script into excel but this was so much more simple thanks 🙏

@shaneechambers6165 2 года назад

THANK YOU! This video is so straightforward. Much more helpful than other videos

@BarthiArgento Год назад

Thanks a lot! In german google sheets, I had to replace all the commas with semicolon, then it worked: =IFS(B2="";"";A2="";now();TRUE;A2)

@philippposchmann8993 7 месяцев назад

Wow danke, ich hab locker ne Stunde rumprobiert. :D

@arturoli 4 месяца назад

Same in spanish

@lesliestanford7617 2 года назад

I had watched many videos using script editor, entering formulas and THIS one made it supper easy and simple!! Thank you

@bricestillman6377 3 года назад

Thank you! Much easier to understand than the other videos on RU-vid.

@rosalycruzc 2 года назад

THANK YOUUU! This is the simplest way I found, I've spent the whole afternoon looking for this formula. Thankkkk youuuu I Love youuuu

@TheGlitterMan 6 дней назад

After trial and error I finally figure it out. Thank you for releasing the video.

@adhisatz3398 2 года назад

This is truly helpful sir, ive been craving this formula for sooo long

@ThePatrickFamilyBand Год назад

You're my hero dude. Thank you for making this cut and dry tutorial for time stamps.

@andrewgreen7234 Год назад

Thank you! I needed it for my simple expense register spreadsheet. Perfect!

@ismaelnatera1323 6 месяцев назад

Thank you so much I have been looking for this all morning on youtube !

@stjohns0 Год назад

Just what I was looking for! Works great - THANKS!!!!

@mansourgaye5298 2 года назад

Simple, easy and Great!!! Thank you

@davidblyth5495 2 года назад

Thanks for a clear explanation!

@debbrower3592 2 года назад

Thanks so very much!!! An easy answer to my problem!!

@IZANAMI_VALORANT Год назад

Love this one, thank you so much mate

@nikhilrastogi7599 3 года назад

Thank you for sharing .. its really helpful

@joeneilpalis9 Год назад

Works Perfect!! Thank you, sensei!

@karinemartineau6819 Год назад

This solution rocks! Thx for sharing!!

@nonononoooll5515 3 года назад

i was looking for this for on month thanks you

@rosalycruzc 2 года назад

Most useful video thank youu!!! God bless you!

@elielberra2867 6 месяцев назад

Finally a good explanation thank you so much!

@cvMouse 3 года назад

Unfortunately every time you reopen the document it recalculates the formula there for the date changes.

@nickjito 2 года назад

Did you ever resolve this issue?

@CapeFearRiverLife 10 месяцев назад

Running into this same problem. How to fix?

@thethinkbot5637 Год назад

You really helped me out brother

@dominicpangilinan3489 2 года назад

thanks for this bro, really helpful

@rodolfolacerdaeduardo7900 Год назад

Excelent!! Thank you so much!

@kockoklosharcheto 3 года назад

Thanks so much!!!

@AllAboutWallpapers Год назад

Thank you! It really works.

@marianafermin2562 2 месяца назад

Thank you so much for this. It is exactly what I needed. 😊

@maxiromero789 2 года назад

Thanks a lot! Im trying to get fundamental data (IS, BS, cash flow) into google sheets. Do you have a video explaning how to do this??

@davvidc 2 года назад

brilliant! thanks a lot.

@art.7577 2 года назад

This is so cool! THX!

@mohitpatel2806 7 месяцев назад

Thanks a lot. Very Helpful.

@allhailtheallmighty 2 года назад

wont the price change each day when we reopen the sheet or is the price locked in from the moment the ticker was entered??

@ruspaul6563 Год назад

thank you , works well !!

@ir9ir9 3 года назад

Very Simple, thank you Sir

@ir9ir9 3 года назад

Plz make a video on ROI along with timestamp next cell/column

@TahaYeşildağ-e4r 19 дней назад

Thank you! It's very helpful

@arabicmath 9 месяцев назад

This is helpful, thank you !

@DKGifford19608 10 месяцев назад

Helpful - thank you. Starts at 3:20

@bhaveshprajapati872 2 года назад

Great one Thank YOu

@casino3824 12 дней назад

It works and is not complicated. Thank you

@ngochuykts 3 года назад

thank you so much!

@TheNewYou2022 Год назад

Thanks man, it works

@Montesmike15 2 года назад

Is there anyway to write the code where when we enter something on ejther Cell B and C Cells A will automatically timestamp instead of just typing on line B?

@sebastiankumlin9542 4 месяца назад

Thank you! It works.

@arvinpaunil7265 Год назад

thank you! This saves my life

@4u2nv247yt 2 года назад

GREAT WORK

@steveroger2847 2 года назад

Hey, how can we do it if any of two or more columns have a value? Suppose, besides "Stock", there's another column "Mutual Funds", so if any of the "Stocks" or "Mutual Funds" column have a value, or both have values, we'll get the timestamp. (EDIT) Made it : [=ifs(and(b2="",c2=""),"",A2="",now(),true,A2)]

@nickjito 2 года назад

Thankyou for sharing @steve!

@grigri62officiel60 10 месяцев назад

Hi ! I watched the video, and it's perfect, it helped me a lot, but I got a problem. When I refresh the internet page, it automaticaly update the time and date, like if it was 0:21 and I refresh at 0:33, it will change the 0:21 for 0:33, how could I change that ?

@NeoMennon 3 года назад

Thank you, this video is great! However I ran into some little problem, when I have multiple lines of records, if I change the content of one of the stock name, some of the date (mine is including hour and minutes) will automatically change as well. Is there any way to make the time stamp unchangeable once it got the time?

@arturoli 4 месяца назад

Thanks a lot, very useful.

@user-ih8qo3nr5s Год назад

Thanks so much for this. You earnt a subscriber

@neodaletakumi3547 3 месяца назад

Still helpful in 2024!! You are a legend!! Thanks mate!!

@brcleaningcompany2566 Год назад

Hey this is awesome,, how do you get Ticker prices into sheets?

@247weed_com5 2 года назад

good job bro!

@GurpreetSingh-hy4vx 3 месяца назад

Thank you very much 👍🏻

@jazzcherylyn Год назад

this tutorial does what it says. thanks!

@muhammadyusufalfatsani4293 Год назад

THANK YOU HOPE UT CHANNEL GROWFAST !!!

@RakeshSingh-yd7xo 2 года назад

Can I use this thing by the script because I already used this formula for almost 2 years but earlier we found a bug date (timestamp) that is automatically changed every time whenever I open the sheet. For solution of this problem I am currently using a script "onedit()" but in this script i am not able to set key value to run this trigger. When I use formula I user If A2="done" then lock the time stamp if A2 ="" then put this cell as null. Please help me.

@tonytenace6451 2 года назад

This was very good. I was looking and using macro scripts. what a pain

@user-uq2ek7rd7q Год назад

Thank you!

@romanbrodsky5702 3 месяца назад

seems to mainly work if the cells are formatted for date! helpful tip!!!

@mamlatdar1girsomnath902 3 года назад

I want data change date-time (Column A) automatically when Column B Value is changed, What should I do?

@yookeecortez9381 2 года назад

Does it able to have time stamp if the editors is not the owner of spreadsheet?

@maurya909 Год назад

Thanku Sir, for this.....

@joeulrich2327 2 года назад

It works but when I close the sheet and open it up the next day that setting doesnt save amd it all errors out. When I put the interval back to 1 then the errors dont change back to the time it was initially changed... any idea how to fix

@anikahmed4401 6 месяцев назад

Thanks a lot.

@constyparthur581 2 года назад

Hello, Thanks for the video which helped me to resolve the automatic timestamps issue; I will need your help if possible on this problem in my sheet… I’ve an issue returning a specific value if two condition (amount>=500 & edate

@alemobetlive Год назад

Noticed that time stamp seconds change by 1 when you save and open for the first time after a new time stamp. Any reason why?

@andiwibowo08 5 месяцев назад

Thanks a lot

@abdughali2687 9 дней назад

Thanks 🎉

@mohakgupta6309 2 года назад

5 ⭐ Thanks Could you please provide last modified in next column also keep freeze first date & time

@rubenstones8684 8 месяцев назад

Ok so my timestamp shows up, but now my formula that counts days from my date stopped working [=datedif(A2,Today(),"d")]. How can i get the datedif function to work with this timestamp formula? Originally i had to enter the date manually and the datedif had no problem calculating days from that, but it does not calculate the days when i introduce the timestamp formula. is there a way to get them both working so that when i write on my cell it triggers both formulas? hope that makes sense.

@Lordblanca Год назад

Wow.. what would be the script if column 1 is green output would be timestamp to cell thanks

@Allen-L-Canada Год назад

Thanks, what if I want the timestamp to show the last modified date and time, without having to delete the data first? Just override the data, then the timestamp is updated.

@dishantgoel158 3 года назад

What if I wanna use it with a tick box?

@KashSheikh786 4 месяца назад

Hey this worked thanks, however i'm having info automatically populate into my google sheets through Zapier and the timestamps don't work here, it seems only when you are manually inputting into the cells they work. Do you know a workaround for this?

@mfatihd88 4 месяца назад

thank you

@kevinjackson8422 3 года назад

I was able to use this quite successfully when entering "new" data, but I notice that I got the date: 12/30/1899 when applied to cells that already had data in them. Any suggestions? Thx.

@TheNewYou2022 Год назад

you can just select the entire cell that containes your previous data, then Hit copy after that u wan to delete all the data in that cell and paste that data again :) Problem should be solved

@grantbullimore 11 месяцев назад

You legend, you fixed my issue lol

@michaelthomas5289 3 года назад

What if I wanted = to or greater than formula?

@tobiasdelabarra6086 5 месяцев назад

Thank you! I wish I had done this from the beginning.. I have a lot of cells without dates :P

@rayg7978 6 месяцев назад

How can I make a PDT tracker? I want have a way to track how many trades I have left.

@DanCisuaka Год назад

Wow this so nice

@x86ed Год назад

Yo thanks so much got everything working but there’s a small problem, when I switch to date/time the time shows up as 0:00:00, any way to fix that?

@ayommanunggal848 11 месяцев назад

ive got the same error, have you found any solution?

@x86ed 11 месяцев назад

@@ayommanunggal848 for me personally it had to do with a setting in excel not available on IOS. I’m not sure if you have IOS also, but I had to get on windows and open excel, adjust the setting then save it and open it on IOS. It’s been months so I can’t remember what that setting was I believe it was in format somewhere?

@sdabrarullah4919 2 года назад

WHAT THE MEANS OF THIS #REF! There is any other setting have to set ? B/c getting error

@wanyeglennasaah2558 2 года назад

what if you change the cell position the time reset

@chandanritvik1 8 месяцев назад

Love ya ♥

@Beautymovesindia 3 месяца назад

sir , as now() is a formula , what will be happened next day. because it is not a value , i think date will be changed. is not ? please tell

@coachjohn1951 3 месяца назад

It only does the now() if the cell is empty. So it only loads the timestamp once.

@ayommanunggal848 11 месяцев назад

Please help, i was set the formula same as the tutorial, but ive got the value is 0, nothing happened, although ive setting the calculation too.. whats wrong?

@gregmuzzi1772 Год назад

I got this IFS formula to work like I want, but sometime throughout the day some of the times read 12:00AM instead of the original time. What is going on?

@arsalanalikhan8885 Год назад

amazing

@anippere Месяц назад

Any idea on how to stop the date changing every time the sheet is closed and then opened again.

@Nova.369 4 месяца назад

how do i update the price too?

@donekalgarisurendra7717 2 года назад

I have small doubt can we get user mail if also?

@donekalgarisurendra7717 2 года назад

Sorry mail id

@bilalmrbj Год назад

helpfull

@ToddHudsonAtl Год назад

Great video. I too needed this for futures trading so I could see if the time of day impacted the success of trades. Thanks!

@TraeFury 2 месяца назад

It works great if I edit the sheet, But I have a set of sheets where I put people to contact and then delegate to my team members. When they edit the cell, it doesn't update the timestamp in the field I selected.