adding created date to another field if its blank

Options

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)


Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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