I need a simple formula in gsheets that will timestamp column b if column a is filled out

[Healingotaku]

I need a simple formula in gsheets that will timestamp column b

 

[fadee2]

Hi, healingotaku,

Now()

can be used for datetimestamp in a cell.

I would suggest providing a little bit of information as to what is actually required, to provide a better understanding of the question.

 

[Healingotaku]

Hi, healingotaku,

Now()

can be used for datetimestamp in a cell.

I would suggest providing a little bit of information as to what is actually required, to provide a better understanding of the question.

I am creating a sign in and out sheet for my clients. I am using a drop-down box in column A. When they select their name I want column B to make a timestamp(of current date and time) of course it would be for each individual cell in column A and B. About 1000 cells in total.

 

[fadee2]

Place below formula in cell adjacent to the cell you have data validation in

if(A1<>"",Now(),"")

This will change cell B1 value to current datetime once the cell A1 changes to anything apart from blank, and if A1 is blank cell B1 will stay blank.

 

[Healingotaku]

Place below formula in cell adjacent to the cell you have data validation in

if(A1<>"",Now(),"")

This will change cell B1 value to current datetime once the cell A1 changes to anything apart from blank, and if A1 is blank cell B1 will stay blank.

So I would I make this formula work for all of column A and B? Sorry for my ignorance

 

[fadee2]

use drag handle to drag the formula down till last used row

 

[Healingotaku]

use drag handle to drag the formula down till last used row

So I highlight all of column b and then put the formula in

 

[fadee2]

So I highlight all of column b and then put the formula in

Lets assume your data starts from A1, paste the formula in B1, and then use the drag handle,

to drag the formula all the way till the end of column B, right next to where your data ends in column A.

Hope this helps...

 

[Peter_SSs]

Place below formula in cell adjacent to the cell you have data validation in

if(A1<>"",Now(),"")

This will change cell B1 value to current datetime once the cell A1 changes to anything apart from blank, and if A1 is blank cell B1 will stay blank.

... but tomorrow when you open the worksheet, do you think this will will still show yesterday's date and time when the cell was changed?

 

[fadee2]

... but tomorrow when you open the worksheet, do you think this will will still show yesterday's date and time when the cell was changed?

thats an excellent question @Peter_SSs, i didnt think of that...
i guess thats why you are an MVP and i m not...?

as for ur question, please correct me if i am wrong, VBA is the way to go???