Convert Formula that pulls a date into a text

Automations 1

Hi,

I have an IF formula in a date column that pulls in a date when criteria are met. I then want to bring that date into a text/number column. I tried a few options, such as =text(Date@row) and =value(Date@row) but it's not working.

Any workarounds?

Thanks!

Jeff Reisman

Try this:

=Date@row+""

This works because it essentially is adding blank text space to the value, and when you add text to any numeric or date value in Smartsheet, Smartsheet converts the whole cell to text.