New answers tagged formula-field
1
vote
What is the proper way to format a formula field so that it is properly spaced
Spacing and parenthesis in the formula itself are mostly about making the formula itself easy for people to read.
To achieve what you're looking for, you need to use more string concatenation (either +...
- 52.1k
2
votes
Created formula field based on condition
Replace fields by API Name of your fields -
IF(ISPICKVAL(Source, 'Social'), TEXT(Work_Start_Date__c) & DS_Employee_Number__c & DS_Absence_Type__c, '')
The return type should be text. You have ...
- 1,187
0
votes
Custom Field Not Showing Up for Opportunity Product
If this were not a formula field, you would need to add the field to the multi-line layout. At the top of the page layout editor for your opportunity product, click Edit Multi-Line Layout.
...
- 24.6k
0
votes
Accepted
IF AND statement not returning correct results
Percent fields are expressed as a decimal (percent means "per 100 parts"). For example, if you pay 5% tax, you'd calculate it as Amount * 1.05; Salesforce stores the percent as a decimal. ...
- 451k
0
votes
Find line break in formula field
You can also do this directly in a Salesforce Flow.
Create a text template variable of type plain text.
In the example it is called "text_T_baseForCRLF"
In the text template write the ...
- 13
2
votes
Formula Field gives error (Compiled formula is too big to execute (15,366 characters). Maximum size is 15,000 characters (Related field: Formula))
What are the compiled costs of each formula function should provide some good insight.
As for a specific recommendation, look at using CASE() instead of that mess of nested IF().
- 52.1k
Top 50 recent answers are included