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

 

[Peter_SSs]

VBA is the way to go???

That is how I would do it in Excel, but this appears to be a Google Sheets question.

 

[Healingotaku]

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???

Do I need to use a script?

 

[fadee2]

Do I need to use a script?

Sorry @Healingotaku, I haven't used google sheets that much.

 

[Healingotaku]

Sorry @Healingotaku, I haven't used google sheets that much.

Its pretty much excel....just like docs...so all the same formulas and scripts work

 

[Healingotaku]

Its pretty much excel....just like docs...so all the same formulas and scripts work

I just don't know excel lol

 

[Joe4]

Its pretty much excel....just like docs...so all the same formulas and scripts work

While it is similar to Excel, it is NOT the same as Excel.
One of the biggest differences is that Google Sheets does NOT support VBA.

That is what we ask people to be sure to clearly mention if they are looking for a Google Sheets answer, but an Excel solution may not work for them in that case.

 

[Healingotaku]

While it is similar to Excel, it is NOT the same as Excel.
One of the biggest differences is that Google Sheets does NOT support VBA.

That is what we ask people to be sure to clearly mention if they are looking for a Google Sheets answer, but an Excel solution may not work for them in that case.

Ok so is there a way to do this my friend in gsheets?

 

[Joe4]

Ok so is there a way to do this my friend in gsheets?

Sorry, I do not know Google Sheets either, so I really cannot help you with that. This is an Excel forum, so most users here know Excel, and only a smaller subset of users have used Google Sheets.
I was just clarifying for you that Excel and Google Sheets are NOT the same thing, and sometimes there are NOT comparable solutions between the two.