What to do if a formula field with an If statement returns text?

242    Asked by Aashishchaursiya in Salesforce , Asked on Aug 30, 2023

I have created a formula field that returns text when 

  1. 1Picklist_Status = Activated; the return text must be A, or it will be null. 

  2. 2Picklist_Status = If it is sold, the return text should be B. Otherwise, it will be null. 

  3. 1Picklist_Status = ChangeofMind. The return text should be C. Otherwise, it will be null. 

There are 2 picklist fields in the Salesforce if formula that can update the formula field if a or b is true. However, I cannot use the OR parameter since my return type is text. What is the solution to this problem? 

Answered by Aashna Saito

: If you include the formula you have used, it can be helpful. You can also use OR() regardless of the return type. 



Your Answer

Interviews

Parent Categories