Formula to convert numbers into a date

Desire

Hi,

In Excel I can turn a set of numbers into dates by using =TEXT(C3;"mm-dd-yyyy").

i.e. 45513,6038194444 is 08-09-2024

Is there a formula in Smartsheet that can do this?

Adam Murphy

Unix timestamp? I don't think smartsheet has a function for this, but you should be able to convert doing something like: =VALUE([Timestamp]@row) / 86400000 + DATE(1970, 1, 1) however your value gives me a different date. Is this not a unix timestamp?

Desire

Thanks Adam

Apparently this is a unix timestamp.

I tried using your formula but I'm getting a #INVALID COLUMN VALUE error