Timestamp - Excel & Google Sheets

Learn how to automatically create a timestamp when data is entered in Google Sheets & Excel using iterative calculations and built in functions.

#Timestamp #Excel #Google Sheets

[omdcosta]

Thank you for the excellent video ! A 100% non coder like me was able to figure out how to implement an autostamp easily. Big ups to you .

[adityasvasisht]

You are a LEGEND! I love your work!
So I tried doing this same tutorial in another way using App Scripts without the need of circular references.
I made this simple function

function timestamp() {

const date_time = new Date();
return date_time
};

now on the google sheet, I made two columns with headers "TimeStamp" & "Name"
"A2" cell would have the formula "=if(B2="", "", timestamp())"

Now if you type anything in B2, a timestamp gets added. Another cool thing is if you re-edit B2, the previous timestamp is still stored and does not get re-written.

[mdamirhossain]

Just awesome. I'm new in G.Sheet, but working in Excel for long. I never know a circular reference can work. Love it.

[dustinkeier]

Thank you SOOOO very much. I have watched several videos and had explanations of the formula, but none noted a very key piece that helped me solve the issue I was having. I needed to find a way to time stamp a cell when "in progress" was entered, and then timestamp another cell when that cell was changed to complete. And It was your explanation of how the IFS formula broke down that finally clicked in to place that pivotal info. in the second time stamp I just needed to enter an additional logical test to test if it was "in progress" and leave blank, so that when the IFS reached the end of the tests it would time stamp accurately. Thank you again so very much!!!

[MrSleep-jvgh]

Timestamp Still change if i fill another cells then i did this

Its works 😅 Thank you

[justfly]

I've never used IFS... I'm always surprised what I learn on here. Thanks for the videos!

[AshleyAiki]

This guy was awesome! I also figured out how to use the checkboxes using this formula here: =ifS(A2=FALSE, "", B2="", NOW(), TRUE, B2) - that took too long but it works. Thank you!

[richardmhain]

These should be useful now that we're aware of timestamp and iteration.
Wondering how auto recalc option affects iteration. Will give it a try sometime.
Thanks!

[apljaaay]

You saved me! More tips and tricks please!

[enisuherni]

Thank You, Thank You, easier than the scripts

[santsangwornrachasup]

Always very helpful. Simply but amazing technique. Thank you!!

[emmikeyzewa]

many thanks and God bless, this has taken me a step foward

[augustomigliori]

W O N D E R F U L !!! Can we actually store data with iterative calc?

[kennethforbin]

I really like this guy. He picks the right things and explains really well. Thanks

[IceCreamHouseLU]

Wow this is really great.
By watching your tutorials, I have made an inventory system shared to our stores (we have 8), all I have to do is protect ranges from the devices/accounts they are using. (We started our business records managements system from the classical paper and forms method)
What if I want to have the last modification to be displayed on the timestamp?

[bocobox]

I am always looking forward to your next video. you really make my eyes open.

[Allen-L-Canada]

just what I was looking for today! I use it to record daily portfolio totals. Work wonderfully!!!

[fredrikpahlsson]

As always - Splendid!
Just one small question; If one use a checkbox (=TRUE or FALSE) in A2 - How do one solve the "else" case (that now is TRUE, which don't work when using the checkbox with the values TRUE or FALSE)?
Any suggestions would be much appreciated.

[daniellewilson]

Few questions about the timestamp formula:

1) I want it to continuously update if the cell has changed not just when it goes from blank to having text. I want timestamp to change each time text changes
2) I want my formula to look at the entire row for changes not just a single cell is that something i can do with this formula?

[jonathanrichardparengkuan]

HI... really helpful with ur videoo.. but want to ask if I want to combine it with array function how to write that formula ?? wait for ur reply ^^