adding created date to another field if its blank

ShaunW

hi i am trying to create a formula that would add the created date into the timestamp field if its blank, i have tried this and it doesn't seem to work, any suggestions

=IF(Timestamp@row, " ", Created@row)

Screenshot 2022-05-02 at 00.32.32.png

Kelly Moore

Hey @ShaunW

Try this

=IF(Timestamp@row="", Created@row)

If the Timestamp column will always equal the date of Created, you could consider having Timestamp mirror the date without an IF statement

=Created@row

Another option would be to use the Record Date automation to record the date when the Created field changes to any value.

Will any of these work for you?

Kelly

*Timestamp must be a DATE column for all of these options to work