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
JaiJai 

Could you please suggest me on this. its not working as expected

Business_Unit__c  ----- picklist
No_of_Employees__c ------ picklist
SPNG_Product__c ----- multi select picklist

when converting a Lead validation has to fire when Business_Unit__c  value is Spanning the No_of_Employees__c  and  SPNG_Product__c are blank.

No_of_Employees__c and SPNG_Product__c these are mandatory fields.

AND(IsConverted, IF( ISPICKVAL( Business_Unit__c , 'Spanning') , AND( ISPICKVAL( No_of_Employees__c , '') , ISBLANK( SPNG_Product__c ) ) , false) )
ShirishaShirisha (Salesforce Developers) 
Hi Jai,

Greetings!

Can you please double check if the No_of_Employees__c field is picklist type or any other.If it is Picklist then the formula should work.Otherwise,try changing the criteria to ISBLANK same SPNG_Product__c.

Please mark it as best answer if it helps you to fix the issue.

Thank you!

Regards,
Shirisha Pathuri
JaiJai
Hi Shirisha,

Thanks for responding,

i changed to below as you suggested even though it is allowing to convert.

AND(IsConverted,  IF( ISPICKVAL( Business_Unit__c , 'Spanning') ,  AND(ISBLANK( NumberOfEmployees ), ISBLANK( SPNG_Product__c )  ) , false)   )