Oh my goodness i have been searching the whole internet but finally i have found it . I desperately needed this. Thank you very much for putting out this vedio tutorial. If it was not for your vedio then i would be searching eternally for a solution. Peace and blessings be upon you.
@Barb Henderson: very helpful video. but I am facing the problems. first iam using 2017. when I entered the data into cell It showed correct time but I went to next cell it show correct time but the previous cell showed 12:00:00 AM or saved the sheet time changed to 12:00:00 AM second it is not working in data validation (dropdown menu). in starting it showed correct but eventually copied the dropdown list.
Thank you! This is great. But how can I make the date and time to change automatically if I change the Shipment info without changing automatically the other shipments date and time? And then, if I filter by shipment the data stays the same without changing?
@@BarbHendersonconsulting I got to make them to keep the first record once adding a "Shipment" even if I filter by Shipment, the date did not change. So, if I want to update the shipment, I have to update the date manually. I have not found the way to make them to update automatically if I update the shipment. Unless I get rid of the 'Enable iterative calculation' but that way every time I filter by Shipment, the date updates in every cell I have the formula, and I do not want that. I would like the date only to be updated automatically if I update the shipment into a new status for example. And then, if I filter, the date does not change at all. I got it using a code TimeStamp ( =EntryTime(##)) but once I filter by Shipment, it updates the Date automatically so, does not work well yet.
Hi Thanks for the video. I get the following error when i do this: We found a problem with this formula. Try ..... I'm doing exactly what u do in the video... what could be the problem?
Since the cell no longer needs to be updated after it has been assigned, does it mean we have made the expression non volatile? Or is the whole expression still volatile just because a volatile function is part of it?
@@BarbHendersonconsulting I tried entering a similar one to Excel and it said "=volatile" irrespective of whether the if function evaluated True or False. I also read somewhere online saying that Excel doesn't optimise for if functions
Hi Barb, I do have a need in opposite way. I have a clock or a kind of stopwatch that generate a time each 15 minutes, and I need to take from one specific cell (only one cell, c2 for example) ) a value and registers that value in different cells (making a list of cells) and the registers stays with the value taken (from c2) and in the other related cell stays with the "time" that a value have been taken and keeping both unchanged. And then, after 15 minutes repeat those events and those are kept in the list unchanged as well, and so on. Could you please help. tks..
With this formula your timestamp will change when you change it's referenced cell. If it doesn't work, try deleting the original cell entry and then placing the updated entry. That should change the timestamp to today's date.
hello, how do i put a formulae to automatically enter only the date, without the time, during data entry? Because this causes a problen when you try to do a pivot table. it doesnt recognise all the similar dates as 1, instead it shows them all separated because each cell has a different time in it.
everytime i filter to look a specific value, the timestamp change it automatically, hmm my question is, if theres any solution that the timestamp will not changing everytime i filter?
I typed in exactly like that =if(B2"", if(A2="", Now(), A2),"") - it says it's not a correct formula... Telling me I need to put values for true and false, and bringing me to the part where is B2"". Like something is missing here.
Hi,@@BarbHendersonconsulting! Thanks for your response, but I've figured out the problem. You use comma and I need to use semicolon - then it works just fine😁. Sorry for disturbing you, and thank you!😊 Thumbs up, all the best!
Hi Barb, excellent video, appreciate for sharing. One small request...suppose I use a sum() formula to enter value in B2 and use the same formula in B3, B4...B7, etc., I wish B2 does not update if B3,B4...B7,etc. updates at a later date & time...help please.
Barb, morning, I have 6 cells, of which one receives the date. I am using nested if's but, something isn't right with the nested if's. I 've put the nested if's in front of your example, not working. Sometimes I get False/True or nothing in the cell. Ideas of samples please! My Sample: =IF(I17"",IF(M17"",IF(N17"",IF(O17"",IF(P17"",IF(H17="",TODAY(),H17),""))))). Thanks in advance.
Oh my goodness i have been searching the whole internet but finally i have found it . I desperately needed this. Thank you very much for putting out this vedio tutorial. If it was not for your vedio then i would be searching eternally for a solution. Peace and blessings be upon you.
happy to help
Same here. Been searching a long time. Thanks
looked at SOOOOO many other tutorials that made it way more complicated. Thanks
I've been trying so hard to get this to work on my own. Thank you so much for the solution!!
You're welcome!!
One of the best beneficial videos I have ever seen
thanks
@Barb Henderson: very helpful video. but I am facing the problems. first iam using 2017. when I entered the data into cell It showed correct time but I went to next cell it show correct time but the previous cell showed 12:00:00 AM
or saved the sheet time changed to 12:00:00 AM
second it is not working in data validation (dropdown menu). in starting it showed correct but eventually copied the dropdown list.
=if(B2"",if(A2="",Now(),A2),"")
This might help.
this is dnamic it will change automatically every time you open the excel , we need it static
Was about to do the same, great job
@@sindbadmasr91 enable iterative calculation, then set the maximum iteration to 1. follow the video...
it works.
Thank you for sharing. Just exactly what I needed. Greetings from Mexico City.
Glad it helped!
Amazing video. I have been searching for this for weeks. Thank you ver very much
Glad it helped
This is exactly the video I needed. Thank you.
Glad it was helpful!
Exactly what i needed. Thank you very very much.
Glad it helped!
Thank you! This is great. But how can I make the date and time to change automatically if I change the Shipment info without changing automatically the other shipments date and time? And then, if I filter by shipment the data stays the same without changing?
If you have one not changing, the other one will have to be changed manually.
@@BarbHendersonconsulting I got to make them to keep the first record once adding a "Shipment" even if I filter by Shipment, the date did not change. So, if I want to update the shipment, I have to update the date manually. I have not found the way to make them to update automatically if I update the shipment. Unless I get rid of the 'Enable iterative calculation' but that way every time I filter by Shipment, the date updates in every cell I have the formula, and I do not want that.
I would like the date only to be updated automatically if I update the shipment into a new status for example. And then, if I filter, the date does not change at all.
I got it using a code TimeStamp ( =EntryTime(##)) but once I filter by Shipment, it updates the Date automatically so, does not work well yet.
Hi
Thanks for the video.
I get the following error when i do this: We found a problem with this formula. Try .....
I'm doing exactly what u do in the video... what could be the problem?
You inspired me about using nested loops in excel formulas. Thanks a lot
Great to hear!
Thanks Barb :) Will try this.
Wonderful!
Thanks a lot it really worked for me.
Glad to hear that
This vid is what I was looking for!!!!! Very useful. Thank you for sharing this method!!!!!
Glad it was helpful!
by enabling iterative computing, will it be affected other functions?
it could!
i love all your videos barb.. very nice content.. can also tell me how to add a sound alert based on cell value changes or make a vide on it plz
thank you, I already have one ruclips.net/video/zJc532DKC0Q/видео.html
Thanks a lot Barb.. helped me solving this issue..
Glad it helped!
Thank you. It was helpful!
So glad!
Since the cell no longer needs to be updated after it has been assigned, does it mean we have made the expression non volatile? Or is the whole expression still volatile just because a volatile function is part of it?
I believe that we have made the expression non volatile
@@BarbHendersonconsulting I tried entering a similar one to Excel and it said "=volatile" irrespective of whether the if function evaluated True or False. I also read somewhere online saying that Excel doesn't optimise for if functions
Hi Barb, I do have a need in opposite way. I have a clock or a kind of stopwatch that generate a time each 15 minutes, and I need to take from one specific cell (only one cell, c2 for example) ) a value and registers that value in different cells (making a list of cells) and the registers stays with the value taken (from c2) and in the other related cell stays with the "time" that a value have been taken and keeping both unchanged. And then, after 15 minutes repeat those events and those are kept in the list unchanged as well, and so on. Could you please help. tks..
maybe this video will help ruclips.net/video/8Jum-vj-LpY/видео.html
Thanks a lot this really helped me
You're welcome!
Woowww awesome.. this really helped me in saving a lot of my time.. thank you Barb..
You are so welcome!
that is what I was looking for . Thanksssssssssss
your welcome!
Awesome tutorial. I have been needing this for a long time. How would you create a timestamp that changes when a cell is updated? Thank you.
With this formula your timestamp will change when you change it's referenced cell. If it doesn't work, try deleting the original cell entry and then placing the updated entry. That should change the timestamp to today's date.
Awesome. I was looking out for this for quite sometime. Really makes life lot easy. Thank you so much!!!!!
Happy to help!
Thank you Ms Barb this is very helpful :)
You are so welcome!
Much appriciated ❤❤❤
thank you
My question is, if someone else opens the document without the circular link checked, will the date change for them?
not sure!
You Da Bomb Barb! Me too, this was EXACTLY what I was looking for!!! THANK YOU!!! It's STATIC!!! WOOO HOOOO!!
Is there a way to Make a button to add a row above the first and keep the functionality of the equation
Entering a line above just have no effect on the formula. Instead of dragging it down, drag the formula up
Great Video!
Thanks!
hello, how do i put a formulae to automatically enter only the date, without the time, during data entry? Because this causes a problen when you try to do a pivot table. it doesnt recognise all the similar dates as 1, instead it shows them all separated because each cell has a different time in it.
if you right-click on a cell and select format cell and select date you are able to select the date only option
thank you so much worked perfectly
You're welcome!
Bard, when I am changing the format to date, it is not showing the correct date and time. Can you help ?
are you right -clicking on the date and selecting format and then selecting the formats for a date?
it's useful tip, Thank You so much
Glad it was helpful!
barb excellent
thank you
You're very welcome!
Hello Barb Henderson I am still having trouble with the date changing automatically in excel after watching this video can you help me.
Did you go to settings to allow circular reference?
You are awesome thank you so much !!!
Glad it helped!
Hello I need to know how to lock the cell with current date.I shouldn't able to type other then current date or future date
Have you seen this video? Lock cell after entry ruclips.net/video/DlSl5Je-4HE/видео.html
Thank you so much 🌹🌹🌹🌹
You're welcome 😊
Excelente. funciona perfecto, gracias por la ayuda. thank you so much
your welcome
This is great but I would like the date inputted instead of the time. How do I do that? Please help.
Insted of NOW() put TODAY()
Hi, Is there any way to protect the formula from erase accidently?
Exactly what I was looking for, Thank you so much for your kind help!
everytime i filter to look a specific value, the timestamp change it automatically, hmm my question is, if theres any solution that the timestamp will not changing everytime i filter?
thanks
Barb Henderson
Welcome!
Hi to add time difference with this formula?
Thank you , Thank you so much.
You are very welcome
I am using excel on android phone...enabling iterative calculation option is not available in mobile version i guess..is there any other way???
I do not think you have this option available, sorry
So I'm typing the code exactly as shown but I get an error that theres a problem with my formula.
did you allow 1 circular reference?
it's help me, thanks!
Happy it helped!
Thanks mam, that was really awesome.....👍☺️👍☺️
Superb. Great Stuff.
Tx Barb. You have my subscription :-)
Awesome, thank you!
I typed in exactly like that =if(B2"", if(A2="", Now(), A2),"") - it says it's not a correct formula... Telling me I need to put values for true and false, and bringing me to the part where is B2"". Like something is missing here.
I just tried it again, exactly as it is written and it worked fine
Hi,@@BarbHendersonconsulting! Thanks for your response, but I've figured out the problem. You use comma and I need to use semicolon - then it works just fine😁. Sorry for disturbing you, and thank you!😊
Thumbs up, all the best!
How do I do this on MacBook Pro? I can't even find Options. Thanks.
I know very little about Mac's except that much of the VBA that I write does not run on a Mac.
This is what I am looking for...Thanks...
Awesome, Excellent and Fantabulous...
Awesome. Hats off to you. Thank you.
Hi Barb, excellent video, appreciate for sharing. One small request...suppose I use a sum() formula to enter value in B2 and use the same formula in B3, B4...B7, etc., I wish B2 does not update if B3,B4...B7,etc. updates at a later date & time...help please.
if i put =today() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell
Have you tried the steps in my video - they work!
Queen of excel
How to use this on QUIP
what is QUIP
Very nice. this helps me a lot. Thanks
so helpful
Glad it was helpful!
i tried this, but the timestamp it keeps returning is january 00, 1900, 12AM
Go over the steps again, if you follow all the steps it should work
Thank you soo much...
Most welcome 😊
I try like you do on tutorials but doesn't work
try the steps again
for every entry its showing the same time
I don't know how that is happening
Awesome... Thanks a LOTTTTTTTTTTTTTTTTTTTTT
Geniuss 🎉
thanks
Thanku mam Love you mam..
I have been searching for a solution for ages, sadly this came close, for some reason it comes back with the date of 0/01/1900 :(
change the cell format from a date.
@@BarbHendersonconsulting Yep, it is set as date.
Thanx
No problem
Thank you
Barb, morning, I have 6 cells, of which one receives the date. I am using nested if's but, something isn't right with the nested if's. I 've put the nested if's in front of your example, not working. Sometimes I get False/True or nothing in the cell. Ideas of samples please! My Sample:
=IF(I17"",IF(M17"",IF(N17"",IF(O17"",IF(P17"",IF(H17="",TODAY(),H17),""))))). Thanks in advance.
Thanks
Great !!
Useful. But... Oops... Doesn't work!
copy my code exactly and replace the "not equal to" with
@@BarbHendersonconsulting hey barb, perhaps this does not work for newer excel? Tried the same way but doesn't work. Any advice?
I wasted more than an hour because of this and did not solve it. Why? Company blocks YT. Well...at least I will have a good night sleep :-) Thanks!
Glad I could help
=SI(A1"";SI(B1="";HOY();B1);"") en español
thank you
HOY OR AHORA ? LOOK...
💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐
thanks, did a thumbs down cause of the date you posted( nothing to do with your work)
the age does not make the information less valuable
Perfect.. Thanks
Glad it helped