Hi,
I run a shared spreadsheet for our staff at work. The currently enter their initials in column A, date in column B, and time in column C (and I know you can put date/time in a single cell but we don't want that).
Is there a way to get a formula in column B if the adjacent cell in column A has anything at all entered into it.
I can get it to insert a live date or time by using:
But really need to get it to insert a static date or time that doesn't update itself. Is it possible?=IF(A1<>"",NOW(),"")
Thanks
Scott
Bookmarks