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
Md Abdul MohitMd Abdul Mohit 

Formula field not populating picklist value.

I have created a formula field. I want to show a text field value if it is not blank.
If it is blank then show a picklist field if that picklist is not blank.
If the picklist field is also blank show a different text field.
I have tried the below formula.
 
IF(NOT(ISNULL(TextField)), TextField, IF(NOT(ISBLANK(TEXT(Picklist))), TEXT(Picklist), TextField_2))

When there is a value in TextField, it is updating correctly. But if is blank and there is a value in the Picklist field it is not showing.
Jaya Karthik karnatiJaya Karthik karnati
Hi Abdul Mohit,

I have tried similar formula in my org and the formula was working as expected.

My formulae: 
IF(NOT(ISBLANK(Site)),Site,IF(NOT(ISBlank(TEXT(AccountSource))),TEXT(AccountSource),Website))

The result :

User-added image

Can you kindly elaborate on the issue you are facing.

Thanks,
Karthik
AnkaiahAnkaiah (Salesforce Developers) 
Hi Abdul,

try with below code.

You need to check ISBLANK instead of ISNULL. ISNULL will not work for text data types. 
IF(NOT(ISBLANK(TextField)), TextField, IF(NOT(ISBLANK(TEXT(Picklist))), TEXT(Picklist), TextField_2))
if this helps, Please mark it as best answer.

Thanks!!
 
Jaya Karthik karnatiJaya Karthik karnati
Hi Abdul,

Hope the previous answer helped your question , if so kindly mark it best answer to close this question. 

Thanks,
Karthik