function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Cali FerrerCali Ferrer 

Getting field values depending on which field been populated

Hi,

Can you please help me what formula will need to use to get field value depending on which field been populated?

I have 2 custom fields:
1. Original Pick
2. Revised Pick

Then, I created formula field "Final_Pick__c". This formula field have a condition of if Original Pick is populated, value should be "Original Pick". Else, value should be Revised Pick.

TYIA!
AnkaiahAnkaiah (Salesforce Developers) 
Hi Cali,

try with below formula. 
If(NOT(ISBLANK(Original_Pick__c)), Original_Pick__c,Revised_Pick__c))

If this helps, Please mark it as best answer.

Thanks!!​​​​​​​
Cali FerrerCali Ferrer
@Ankaiah thank you for your response. I have tried this given formula of yours and it only works on "Original Pick". I tried adding 1 value on "Original Pick" then it completely throw 1 value as well on "Final Pick" However, it didn't work on "Revised Pick" field.

When not populating the "Original Pick" field, "Final Pick" didn't get the "Revised Pick" value instead.

Is there anything might missing? TYIA again! really appreciated
AnkaiahAnkaiah (Salesforce Developers) 
Hi Cali,

If the "Original Pick" filed value blank then "Final Pick"  field will have "Revised Pick" field value.

Thanks!! 
Salesforce TechieSalesforce Techie
Hi,

try
IF(NOT(ISBLANK(TEXT(Original_Pick__c))), TEXT(Original_Pick__c),TEXT(Revised_Pick__c))
Cali FerrerCali Ferrer

Hi @Ankaiah

 

"Final Pick" still not getting the "Revised Pick" field value when I put empty value on "Original Pick" field.

TYIA!
Cali FerrerCali Ferrer

Hi @Trainee

I tried as well your given formula but same results as well. "Final Pick" still not getting the "Revised Pick" field value when I put empty value on "Original Pick" field. Perhaps there's missing on the function?

TYIA!
seniesz joeseniesz joe
Great Post! Thank you for visiting here. Taco Bell Menu Prices UK (https://ukmenuprice.today/taco-bell-menu-prices/)
Dylan Hughes 12Dylan Hughes 12
I am not a regular user but i share some information, Click on SetUp (Gear Icon) and then click on the Object Manager. Click on the object you will be adding the Lookup field to. ... Select Fields & Relationships and then click the New. Select Lookup Relationship from the Data Type list and click Next.  
I hope this information will be helpful for you !!!!!!!
Riley NathanRiley Nathan
"Final Pick" still not getting the "Revised Pick" field value when I put empty value on "Original Pick" field. https://www.mythdhr.biz/