Skip to main content
Topics#Reports & DashboardsThomas Schwenn's Question
Thomas Schwenn asked in #Reports & Dashboards
Jul 12, 2019, 6:39 PM

validation rule for long text field

I'm looking to make make a Long Text Field required as a dependent field based on certain selctions of a picklist. However, none of the formulas I've tried are working (see below). I tried to make it required in Layouts, but it was becoming required all the time (not just based on the controlling field)

 

Any guidance is appreciated.

 

Dependent Field - Long Text Field: Additional_Details_for_Outcome

 

Controlling Field - Split_Stage__c

 

Picklist values (for controlling field): 

 

Pitch Win (Competitive)

 

Pitch Win (Non-Competitive)

 

Awarded Without a Pitch

 

RFI/RFP - Did Not Advance

 

Pitch Loss (Competitive)

 

Pitch Loss (Non-Competitive)

 

Cancelled

 

Pass

 

Pitch Withdrawal

 

Referred to a Publicis Health Agency

 

Referred to a Groupe Agency

 

Closed Won

 

Pitch Loss (to another Publicis Agency)

 

(TEXT(Split_Stage__c) = 'Pitch Win (Competitive)'|| 

 

TEXT(Split_Stage__c) = 'Pitch Win (Non-Competitive)'|| 

 

TEXT(Split_Stage__c) = 'Awarded Without a Pitch'|| 

 

TEXT(Split_Stage__c) = 'RFI/RFP - Did Not Advance'|| 

 

TEXT(Split_Stage__c) = 'Pitch Loss (Competitive)'|| 

 

TEXT(Split_Stage__c) = 'Pitch Loss (Non-Competitive)'|| 

 

TEXT(Split_Stage__c) = 'Cancelled'|| 

 

TEXT(Split_Stage__c) = 'Pass'|| 

 

TEXT(Split_Stage__c) = 'Pitch Withdrawal'|| 

 

TEXT(Split_Stage__c) = 'Referred to a Publicis Health Agency'|| 

 

TEXT(Split_Stage__c) = 'Referred to a Groupe Agency'|| 

 

TEXT(Split_Stage__c) = 'Closed Won'|| 

 

TEXT(Split_Stage__c) = 'Pitch Loss (to another Publicis Agency)') 

 

&& 

 

ISBLANK(Additional_Details_for_Outcome__c,"")

 

Error: Incorrect number of parameters for function 'ISBLANK()'. Expected 1, received 2
2 answers
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    Jul 12, 2019, 6:42 PM

    Try this = 

    AND(
        CASE(
            Split_Stage__c,
            'Pitch Win (Competitive)',                  1,
            'Pitch Win (Non-Competitive)',              1,
            'Awarded Without a Pitch',                  1,
            'RFI/RFP - Did Not Advance',                1,
            'Pitch Loss (Competitive)',                 1,
            'Pitch Loss (Non-Competitive)',             1,
            'Cancelled',                                1,
            'Pass',                                     1,
            'Pitch Withdrawal',                         1,
            'Referred to a Publicis Health Agency',     1,
            'Referred to a Groupe Agency',              1,
            'Closed Won',                               1,
            'Pitch Loss (to another Publicis Agency)',  1,
            0
        ) = 1,
        LEN(Additional_Details_for_Outcome__c) = 0
    )
Write an answer...
0/9000