The part before the first comma is the condition that is (IF) true (THEN) the field will be set to the value between the first comma and second comma. If the condition is false (ELSE) the field will be set to the value after the second comma.
Full Answer
Does it matter what the result of is in Salesforce?
If you have TRUE || <something>, it doesn't matter what the result of <something> is because if any part of an OR expression is true, the entire thing is true. We (well, Salesforce) can skip evaluating the entirety of <something>.
What do you think about the Salesforce formula field?
The Salesforce formula field is a wacky one, that's true. I hate working with it, but do have a couple of pointers. The IF statement is pretty easy to get a handle on.
What is IF-ELSE logic in Salesforce flows?
Salesforce flows give us the ability to create business logic by using clicks not code. In this blog, we will look at if-else logic in Salesforce flows. We will create a full if-else example that you can try out in your own org.
What is the best way to write an IF statement?
The IF statement is pretty easy to get a handle on. Think of it as a 3 part function. IF (isTrue, then-thing, else-thing) If you want a nested condition, put that in the else-thing part.
How does the IF formula work in Salesforce?
Using the IF() function This function checks whether a condition returns true. If it does, it will return the first value defined; otherwise, it will return the second value, for example, IF(RowCount > 4, WON:SUM, CLOSED:SUM) .
Can we use if else in formula field salesforce?
You can create the formula using nested if-else condition. It would look something like this. If(ISPICKVAL(Name_Picklist_Field, 'contract type a'),'x',IF(ISPICKVAL(Name_Picklist_Field, 'contract type b'),'y','0')) and so on. Replace the Name_Picklist_Field with the name of your picklist field api name.
What is if condition in Salesforce?
If else statements are used to control the conditional statement that are based on various conditions. It is used to execute the statement code block if the expression is true. Otherwise, it executes else statement code block.
How do I use Ispickval in Salesforce?
ISPICKVAL(picklist_field, text_value) returns true if the value of picklist_field matches text_value, and false otherwise. You can combine ISPICKVAL() with PRIORVALUE(). You can use this function in assignment rules, validation rules, field updates, and workflow rules to find the previous value of a field.
What does == mean in Salesforce formula?
Evaluates if two values are equivalent. The = and == operators are interchangeable. <> and != (Not Equal) Evaluates if two values aren't equivalent.
Can we use IsChanged in formula field?
Use IsNew(), IsChanged() and PriorValue() in Flow Formulas. A very much awaited feature is coming in Summer '21 – we will have the ability to use the IsNew(), IsChanged() and PriorValue() syntax in formulas as you can in workflow rules and processes in record-triggered and scheduled flows.
Can you use and in an if statement in Salesforce?
You can use && and || operators in if statements as well. Another option in apex is to use switch statements.
What does the if statement do?
The IF statement is a decision-making statement that guides a program to make decisions based on specified criteria. The IF statement executes one set of code if a specified condition is met (TRUE) or another set of code evaluates to FALSE.
How many ORs can you have in an if statement?
Using an OR keyword You can use up to 13 ORs in a condition.
What is Priorvalue in Salesforce?
The PRIORVALUE function gets the previous value of a field that is the same value if the record is being created, or the real previous value if the record is being updated.
What is Isnew function in Salesforce?
The ISNEW() function allows you to make a process builder node apply only to newly created records. This is very useful when consolidating workflows into Process builder or making automations that need different criteria depending on whether a record is being created or edited.
Can we use picklist field in formula Salesforce?
A picklist field lets you choose a value from a pre-populated list. While you can't write a formula that returns a picklist as a result, you likely have to reference picklists in your formula fields.
Another thing
There's also short-circuit evaluation to keep in mind. If you have TRUE || <something>, it doesn't matter what the result of <something> is because if any part of an OR expression is true, the entire thing is true. We (well, Salesforce) can skip evaluating the entirety of <something>.
Putting it together
I have to make the assumption that the thing you're having trouble with is the else if (OldStatus == 'B' && NewStatus != 'C' || NewStatus != 'A' ) in your example (your question isn't clear enough to know that this is indeed the issue).
