I am at the moment working on creating a form that will be used at work.
In doing so I'd like the form to automatically timestamp itself upon creation. It appeared however, that that was not easily doable and so I set out to find an alternative solution.
I stumbled upon this formula:
The function is supposed to be inserted into B2 and should only return a timestamp when something is entered in A2 - but every time I insert the function in B2 I get an error asking me if I am really trying to insert text rather than a function..?
I ended up solving the problem by changing the function to: =IF(A2<>"";TODAY();"")
But - I would love to know if you can figure out what caused the first function to malfunction?