Timestamp error

[Hmsbatman]

Hi all.

I’m tyring to insert a time stamp in calc but every time I use the formula =IF(A2<>"",IF(B2<>"",B2,NOW()),"") it returns a error but this can be overcome by adjusting the size of the cell. I can have multiple cells that have a time stamp and the cells will all require adjustment to correct. It’s almost working but not quite
Tia

[anon73440385]

Hello,

probably you get ### - but this is not an error, just an indicator that the data do not fit into cell. In that sense adjusting column width doesn’t fix an error but accomplishes room for the value to be displayed