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
HNT_NeoHNT_Neo 

Picklist = Value then these fields are required

Hello everyone,

Looking for a validation rule for the following: 

When the picklist "DAO_Step__c" = Max Sort

the following number fields are required in order to save the record and must not be left blank: 

Arts_Gain__c
Destined_Col__c
DAO_Opp__c
Plus_A__c
Frameing_Back__c

Best Answer chosen by HNT_Neo
Boris BachovskiBoris Bachovski
ISPICKVAL("DAO_Step__c", "Max Sort") && ISBLANK(Arts_Gain__c) && ISBLANK(Destined_Col__c) && ISBLANK(DAO_Opp__c) && ISBLANK(Plus_A__c) && ISBLANK(Frameing_Back__c)

 

All Answers

Boris BachovskiBoris Bachovski
ISPICKVAL("DAO_Step__c", "Max Sort") && ISBLANK(Arts_Gain__c) && ISBLANK(Destined_Col__c) && ISBLANK(DAO_Opp__c) && ISBLANK(Plus_A__c) && ISBLANK(Frameing_Back__c)

 
This was selected as the best answer
HNT_NeoHNT_Neo
Thank you Boris!