Google Sheets - Add timestamp on a cell change #googlesheets #googlesheetstutorial #googlesheetstips

Learn how to add a timestamp when cell is updated in Google Sheets.
#googlesheets #googlesheetstutorial #googlesheetstips

[portant]

Formula: =IFS (A2="", "" ‚B2<>"", B2, 1*1, Now ())

[jeffbrown]

I REALLY appreciate that this video is 1 minute long. This wasted NONE of my time. Other people making these types of videos would have made it 8 minutes long. Cheers!

[kensioson]

Thanks for this tutorial! It's incredibly timesaving. Your channel is very helpful.

[reshamm]

This is so helpful rather than doing the appscript which i cannot work for the life of me as a non-coder. Thank you so much! Subscribed just for making things easier rather than convenient. LOL

[gbrtkel]

Liking and subscribing because this just saved my life, thank you!

[balkarsingh]

Very Good solution! We are now using this for 1000s of shipments being processed at our FC. Many thanks! 🙂

[apondo]

you are amazing. thankyou. getting your head around google sheets can be really hard..

[matilacrampette]

Worked perfectly, thansk man! Greetings from Chile

[MrWestSky]

This was SO GOOD, thank you so much!!!

[nzixesq]

You're a saint mate! So resolute! Thank you.

[helperwheatley]

hey! been using this at work and it’s been awesome so far! however, i do notice i run into the occasional issue where the cell input generates a decimal timestamp value (something like 41666.9) and fixing it updates the whole column of timestamps with the very top set to 30/12/1899. and, it seems when i copy and paste blank cells that have been colored (i have to extend my sheet sometimes) also seems to nuke the timestamp column with a reference error

[wildhanr]

Hey, great videos. Thanks for the concise and straightforward explanation, I'm just wondering how can 1*1 froze the NOW() process?

[yuenwne]

thanks for the instruction, i can even use it for array formula.

[thfwucy]

Thank you so much. Is there a way it updates its self when editing it with a new entry?

[SlavIliev]

Great Job! You saved the day, thank you!

[andrdrdry]

HI! I used this formula but I'm running into the issue where when I open the sheet and add a new timestamp, the timestamps from the previous day all changed into the current timestamp. Do you know why this is happening?

[alirezakoraee]

thank you, clear instructions and it worked

[igorkredentser]

What if I want the timestamp to be creative only in case if the cell filled with exact value?
As example, "yes" only, and ignoring all other values

[Nova.]

Can i automate this to add the formula when i insert a new row?

[avinavkumarpandey]

Hi James!
What does B2<> and b2, 1*1 means ?

I have an idea for break calculation where wherever i go outside and comment in a column break starts and when i came back, comment break stops and it calculates the break.
It has to be used by multiple user in a group

Thanks and Regards
Avinav