Having issue in =IF(F6<>"",IF(B6="",NOW(),B6),"") function

[waqarhq]

Hi;
I am preparing sheet for document controller;
I want to put time stamp automatically with this =IF(F6<>"",IF(B6="",NOW(),B6),"") function.
but when I post data to new row the time of all rows refresh automatically.

I want it to pick time while posting in particular row and keep it forever.
and only update the row in which i am posting info.
Please help me to fix this function or any other solution for static time stamp.

Regards

[jeffreybrown]

You will need VBA to do this. With your formula, the NOW() is a volatile function so anytime a change is made on the spreadsheet, the NOW() will update. NOW() returns the day along with the time.

[waqarhq]

I tried a code to fix it
but still....

this was the code

Please Login or Register  to view this content.

[Glenn Kennedy]

You can get it to work witout VBA, if you enable iterative calculations. When that's done, this will give you a non-updating datestamp in B2 as soon as anything is entered in A2.

=IF(A2="","",IF(B2="",NOW(),B2))

[waqarhq]

Thanks glenn
but same issue
as soon as i post in new row
all cells of time stamp show new time

[Glenn Kennedy]

You're doing something wrong. see attached sheet.

Have you enabled iterative calculations?

[waqarhq]

Wow perfect
thanks

according to this i will put my data before the formula cell, right

or i can populate data on both sides of formula cell?
I am asking this to prepare my tamplate

thanks again boss

[Glenn Kennedy]

It's up to you. I mrmally ise this so that as soon as the first entry is mafe in a row (usually column A), then the datestamp updates. If you run into problems, do ssk.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.