New answers tagged formula
0
votes
Date/time field is not populating although syntax is working
What field type is Time_of_the_Day__c? Is it a picklist value? If so, have you tried ISPICKVAL() instead?
IF(
ISPICKVAL(Time_of_the_Day__c, "Morning (09:00 - 13:00"),
DATETIMEVALUE(...
- 3
0
votes
Incoming chats per hour in a report
So, I don't have firsthand experience of chats myself (assuming they're the ones described here), but if they have a "Created Date" field, that seems the most promising direction for reports....
- 121
0
votes
IF statement for Distance - Flow
The IF function always takes three parameters. You need to update your IF so it has the condition and the two resulting values. Since you are only interested in whether the condition is met (or not) ...
- 30.6k
0
votes
Validation Rule at Closed Case
The nature of AND() means that if any of the conditions are false, then the entire result is false.
So if one of your two target fields are filled in, then the ISBLANK() returns false, and your ...
- 53.4k
0
votes
Setting up Validation Rule based on checkbox value
It also helps a lot to include the API names and data types.
AND(ISPICKVAL(Status,"Application Sent"), District_Approved__c = FALSE)
0
votes
Accepted
Date population
This formula would be better handled simply using:
ADDMONTHS(CloseDate, 12)
As per the documentation:
Returns the date that is the indicated number of months before or after a specified date. If the ...
- 30.6k
2
votes
Help combining "AND" and "OR" into one formula
Separate out the last three items with extra brackets:
{!$Record.BMCServiceDesk__state__c} = False &&
{!$Record.BMCServiceDesk__followUp__c} = False &&
ISBLANK( {!$Record....
- 19.5k
0
votes
Formula for Is Current Fiscal Year Checkbox Based on Date
The formula is below:
IF(
IF(
(MONTH( Today() ) >= 6 && MONTH( Today() ) <= 12),
((YEAR( Today() )+ 1)),
((YEAR( Today() )) )
)
=
IF(
(...
1
vote
Accepted
Help with a formula field to display traffic light image
As I laid out in my comment, properly formatting your formula is the first step here. It has a tendendy to make it extremely clear where the most common mistakes happen.
In your case, the issue is in ...
- 53.4k
0
votes
Accepted
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 1 on Validation Rule
It's easy to get lost in a sea of parenthesis. To help avoid that, the recommendation is that you treat formulas like code. One statement per line, and indent an additional level with each open ...
- 53.4k
Top 50 recent answers are included
Related Tags
formula × 1686formula-field × 427
apex × 138
validation-rule × 133
workflow × 119
process-builder × 102
validation × 99
date × 91
visual-workflow × 80
picklist × 79
custom-field × 77
datetime × 67
reporting × 65
visualforce × 58
trigger × 51
field-update × 37
case × 30
opportunity × 30
administration × 29
roll-up-summary × 27
if × 27
custom-object × 24
lookup × 24
fields × 21
image-formula × 21