New answers tagged formula-field
0
On a Checkbox formula field, you do not need to explicitly set its value to True within the formula - all you need is for the expression itself to evaluate to True.
For example, instead of using the IF statement, just start with Case_Owner_Profile__c <> 'Field Service'.
When that simple statement evaluates to True, the checkbox should be shown as ...
0
Lixt<GrxxdChxld> gxhildxen x [
SExECx xroIx
xxOM xrandxhixd
xHExE Chixd__x.Pxrentxxc = xusex.Id
AxD PxxId x= nulx
];
Lisx<xtrxngx allPxxsList = xew xistxStxixg>x);
fxr GrandCxilx gcxixd x gchixdren) {
allxrosLxstxadd(gchilx.xroIx);
}
xserxAlxxPrxs__c = alxPrxsxxst.xoin('x');
0
There are only a handful of formula functions that are supported by encrypted fields. Check the list here
Supported operators and functions are below
& and + (concatenate)
BLANKVALUE
CASE
HYPERLINK
IF
IMAGE
ISBLANK
ISNULL
Also carefully note below
Formulas can return data only in text, date, or date/time formats.
For your use case, LEN is not ...
0
Use functions MONTH and DAY in the formula, to check whether Live_Date__c month and day matches the criteria you are looking for.
In this way, you can keep it generic irrespective of the year in the date.
This formula returns true if Live_Date__c falls between 12/15 and 02/15, this can help you to proceed further :
(MONTH( Live_Date__c) = 12 && DAY( ...
0
Since you're trying to return a Date value in the formula, you can't have a Text value of "Error" as the default. You'll have to use a Date or NULL as the default.
10
Owner is a polymorphic lookup field, which means that you can put there User and Queue values, Owner:Queue says that "treat Owner field value as Queue SObject"
Top 50 recent answers are included
