Hello,

Sorry if this has been asked before, I tried searching but couldn't find the answer. I have two columns: A and B. When A is filled then I need B to auto populate with the date and time.
I have tried "=IF(A="","",NOW())" but the issue here is that when I fill any field in A, it will set the entire sheet to the current date time.