I have quite similar problem, but a little more complicated.
So, I have "A" column as an adding date (DD.MM.), but I want it to be automated without changing anymore..
I want the timestamp to appear to "A" when an item name is added to "B" column, the same row of course.
I want also, that the old timestamp won't change to current date even if "B" value is changed..
A second request, if easily done (not so important) is to be able to manually change the date, without taking away the formula from the cell..
Note that that formula result will change every time a calculation takes place. Is that what you want or do you want the date/time stamp to be static once data is entered? If so, then you won't be able to use that formula.
yes that one is good.Thanks
Do you know the correct format for a cell that will let you enter a @ without it seeing it as a email. Example: this is a steel size, 3@5. I have tried General and Text and it still turns it blue as it were email..