Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jenell_LJenell_L 

Formula Help

I have a set of custom fields and a checkbox field. I want my custom fields to be required if the checkbox is checked. Below is the formula I came up with based on the examples... but I can't get it to work as I explained above. How should my formula look to achieve this validation rule?

AND (
  OR (
    ISNULL ( Meeting_Date__c ),
    ISNULL ( Account_Attendees_and_Title__c ),
    ISNULL ( Purpose_of_Meeting__c ),
    ISNULL ( Key_Take_Aways__c ),
    ISNULL ( UOLMG_Attendees__c ),
    ISPICKVAL ( Meeting_Type__c , "--NONE--"),
Send_Call_Report_Email__c = TRUE
))
kim_lebiczkim_lebicz
Try using CHECKED instead of TRUE
NPMNPM

Are any of the fileds you are checking for null Text type fields?  I do not belive ISNULL works for Text fields.

Check out the TIPS when you search on ISNULL in Help and Training and then select Operators and Functions > ISNULL

 

 
Jenell_LJenell_L
Do you know which one will verify that a text field is not blank? (I'm going to go look thru the options, but if you know do let e know! Thanks). :)
Jenell_LJenell_L
Thanks. I think that the true works... but I will try.
kim_lebiczkim_lebicz
LEN function works for text fields. For example:
 
LEN( fieldname ) = 0
Jenell_LJenell_L
To close the loop.. .below is the final formula which worked. THANKS for the help! :)

Code:
AND (
Send_Call_Report_Email__c = TRUE,
  OR ( 
    ISNULL ( Meeting_Date__c ),
    LEN ( Account_Attendees_and_Title__c ) = 0 ,
    LEN ( Purpose_of_Meeting__c ) = 0,
    LEN ( Key_Take_Aways__c ) = 0,
    LEN (  UOLMG_Attendees__c ) = 0,
    ISPICKVAL ( Meeting_Type__c , "--NONE--" )
))