Ask Search:
Lorraine SchiestelLorraine Schiestel 

Formula field that will enter values from other fields

Hello,

I am wondering if it is possible to create a formula field that can pull information from potentially 3 different fields. Right now there's 3 phone numbers that can be listed, but I want to create one field which would show the first number we can contact. 

For example, if we had phone numbers like this:
Primary Phone: (blank)
Secondary Phone: 123-456-7890
Alternative Phone: (blank)

I want to have a field that would pull the information from the first field and put the phone number. If that field is blank, it can then put the phone number from the 2nd phone option. If that one is also blank, it should then put the number that is listed in the 3rd field. 

Is it possible to set up a formula field like this? I think it would need an ifblank statement but I don't know if this is possible or how it could be set up. 

Thanks!
 
Best Answer chosen by Lorraine Schiestel
Deepak AnandDeepak Anand
Like this = 
BLANKVALUE(First_Field__c, BLANKVALUE(Second_Field__c, Third_Field__c))

All Answers

Deepak AnandDeepak Anand
Like this = 
BLANKVALUE(First_Field__c, BLANKVALUE(Second_Field__c, Third_Field__c))
This was selected as the best answer
Lorraine SchiestelLorraine Schiestel
That worked, thank you!!