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)
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives