New answers tagged

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....
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....
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