Formula Field for Date
I'm creating a formula field called "First Contact Date". If a field called "Custom Created Date" is populated (data from our CRM migration a few months ago) I'd like the field to show that date. If there is not data in that field (i.e. a lead has been created post-migration) then I'd like to it populate with Salesforce's "Created Date" field.
I've been working with the BLANKVALUE and IF operators and unsure if I'm on the right track. Thanks!
(translation: if your custom field is blank, display the value of the default created date, otherwise display your custom created date value)
Plug in the custom created date API name where applicable above (remove the quotes around my placeholder)