I found this: =IF(OR(B43"",C43""), lambda(x,x)(now()), ""). I don't know why it works, but adding the lambda(x,x) makes just the value part of the cell and not the formula. I do use this for tracking paper trades in stocks and it infuriated me every time the cells would reset!
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 ?
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)]
@@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?
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.
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?
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?
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?
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.
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.
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.
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
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?
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?
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.
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
That's very nice. I know you're probably going to think that I am the worst person on earth but what if you wanted the date stamp to appear every time you made a change in the entire row [not just in one cell] ❓
The shortcut is not working for me and it is driving me insane. I have tried changing the spreadsheet settings, the keyboard input settings, and more to make it do it, but it just refuses. I don't see anything online for troubleshooting this problem.
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)
Wow danke, ich hab locker ne Stunde rumprobiert. :D
Same in spanish
woww thank you
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!
Helpful - thank you. Starts at 3:20
Unfortunately every time you reopen the document it recalculates the formula there for the date changes.
Did you ever resolve this issue?
Running into this same problem. How to fix?
I found this: =IF(OR(B43"",C43""), lambda(x,x)(now()), ""). I don't know why it works, but adding the lambda(x,x) makes just the value part of the cell and not the formula. I do use this for tracking paper trades in stocks and it infuriated me every time the cells would reset!
Thank you so much, other channels describe only true cases, but you have described perfectly even if it does not work. FANTASTIC!
THE EASIEST, THE MOST SIMPLE THE BESTTTTTTT
Wonderful video, very helpful ...must watch till the end for it to make sense.
After trial and error I finally figure it out. Thank you for releasing the video.
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 ?
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)]
Thankyou for sharing @steve!
Thank you so much I have been looking for this all morning on youtube !
THANK YOU! This video is so straightforward. Much more helpful than other videos
Thank you! Much easier to understand than the other videos on UA-cam.
Still helpful in 2024!! You are a legend!! Thanks mate!!
I had watched many videos using script editor, entering formulas and THIS one made it supper easy and simple!! Thank you
Thank you! Was watching another video and it was putting a script into excel but this was so much more simple thanks 🙏
Finally a good explanation thank you so much!
You really helped me out brother
You're my hero dude. Thank you for making this cut and dry tutorial for time stamps.
Extremely valuable formula: =Value(Hour(now()+time(2,0,0)))+value(minute(now()))/60 now() time zone adjusted, minutes as %
wont the price change each day when we reopen the sheet or is the price locked in from the moment the ticker was entered??
It works and is not complicated. Thank you
this was so helpful in my work.. thank you so much, subscription to this channel also done..
seems to mainly work if the cells are formatted for date! helpful tip!!!
Wow this so nice
Thank you! I needed it for my simple expense register spreadsheet. Perfect!
Thank you so much for this. It is exactly what I needed. 😊
Thanks for saving my time.
This solution rocks! Thx for sharing!!
THANK YOU HOPE UT CHANNEL GROWFAST !!!
Just what I was looking for! Works great - THANKS!!!!
Thanks so very much!!! An easy answer to my problem!!
GREAT WORK
Thanks for a clear explanation!
thank you! This saves my life
Thank you! That was really helpful
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?
ive got the same error, have you found any solution?
@@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?
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.
Works Perfect!! Thank you, sensei!
Thanks so much for this. You earnt a subscriber
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?
This is truly helpful sir, ive been craving this formula for sooo long
Thank you! It's very helpful
This is helpful, thank you !
Love this one, thank you so much mate
i was looking for this for on month thanks you
Thank you! It really works.
thanks for this bro, really helpful
Thanks man, it works
Dude, thank you!
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??
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?
Excelent!! Thank you so much!
Thanks a lot. Very Helpful.
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?
Any idea on how to stop the date changing every time the sheet is closed and then opened again.
this tutorial does what it says. thanks!
The odd thing is it uses the date and time of the server that it is running on and. Not my PC date and time.
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.
good job bro!
Thanks so much!!!
Thank you HACKED it>>>
Thank you for sharing .. its really helpful
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.
This is so cool! THX!
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?
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.
Simple, easy and Great!!!
Thank you
SUPPER HELPFULLLLL
Thank you! I wish I had done this from the beginning.. I have a lot of cells without dates :P
Hey this is awesome,, how do you get Ticker prices into sheets?
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
This was very good. I was looking and using macro scripts. what a pain
Wow.. what would be the script if column 1 is green output would be timestamp to cell thanks
Thank you!
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?
WHAT THE MEANS OF THIS #REF!
There is any other setting have to set ? B/c getting error
How can I make a PDT tracker? I want have a way to track how many trades I have left.
Very Simple, thank you Sir
Plz make a video on ROI along with timestamp next cell/column
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?
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.
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
You legend, you fixed my issue lol
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
It only does the now() if the cell is empty. So it only loads the timestamp once.
That's very nice. I know you're probably going to think that I am the worst person on earth but what if you wanted the date stamp to appear every time you made a change in the entire row [not just in one cell] ❓
Does it able to have time stamp if the editors is not the owner of spreadsheet?
how do i update the price too?
can u help with how to add time instead of date?
The shortcut is not working for me and it is driving me insane. I have tried changing the spreadsheet settings, the keyboard input settings, and more to make it do it, but it just refuses. I don't see anything online for troubleshooting this problem.
how every i am trying but getting "Range" not defined please guide
Thanks 🎉
I want data change date-time (Column A) automatically when Column B Value is changed, What should I do?
if we use this iterative setting , then sheet response time is very very low
Can you do this with a matrix. If yes, how to?
Good luck 👍
Sorry but this won't work because NOW function updates
Yes, He is right. Any way to fix this?
thank you so much!
5 ⭐ Thanks
Could you please provide last modified in next column also keep freeze first date & time
Thanku Sir, for this.....
Love ya ♥
Thanks a lot.
HUGE PROBLEM: In Google Sheets, I have about 7 tabs, 2 of which information seemed to just have disappeared! Anyway I can go back I locate?
Did it disappear after changing the iterations? And google sheets has history logs so you can go back that way