New answers tagged formula
0
If the lookup field is located on the Opportunity, then your Opportunity has exactly one or exactly zero related records. A lookup field cannot point to more than one record, and it doesn't matter how many other records might be considered "related" based on the business semantics of your data unless you build automation to consider those records.
Workflow ...
1
Probably the most common issue with formula syntax is mismatched parenthesis, or missing commas.
Being rigorous with the formatting (even though it won't appear formatted in Salesforce, until you go to edit the formula, that is) can really help make errors more apparent. Consistency and keeping each line fairly short/self-contained are key here. Applying ...
0
Here is my attempt at your requirement with both a verbose explanation and a minified version:
IF
(
OR
(
//First Scenario Where Sales Type is Open Order and TODAY's date is greater than Scheduled Ship Date
AND
(
TODAY() > Scheduled_Ship_Date__c,
Line_Status__c = 'OPEN'
),
//Second ...
1
based on doc you should try ISBLANK
AND(NOT(ISBLANK([Lead].Source_Opportunity__c)),
(ISBLANK(TEXT([Lead].Source_Opportunity__r.Source_details__c)) &&
NOT(ISBLANK(TEXT([Lead].LeadSource))) &&
ISPICKVAL([Lead].LeadSource , 'Trig') &&
NOT(ISBLANK(TEXT([Lead].Source_Opportunity__r.Business_Line__c))) &&
ISPICKVAL([Lead]....
0
You can use this formula expression in your formula field.
IF(
BEGINS(Name, '4'), 'VISA',
IF(
BEGINS(Name, '5'), 'MC', ''
)
)
Top 50 recent answers are included
