function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Craig OverpeckCraig Overpeck 

Creating dependent fields

I am trying to create a field dependency which makes one field required when another is marked as yes. The field that I am trying tomake required (If_IBO_Renewal_Date__c ) is a date field, not a picklist, so I am unable to write a formula wtihout errors.  Any thoughts on how to structure this?  My current formula is below. Thanks!

AND(OR( ISPICKVAL( IBO__c ,"Yes"), (OR((
ISPICKVAL(If_IBO_Renewal_Date__c , "" ))))))
Roman RiabenskyiRoman Riabenskyi
Hello Craig
Try this:
AND( ISPICKVAL(IBO__c ,"Yes"),
ISBLANK(If_IBO_Renewal_Date__c))