+ Start a Discussion
lincylincy 

i have a picklist field we should make it required if the stage(picklist field) is other than initiated

Can any one have idea how to write a formula for two fields which were of picklist type and stage is other than initiated
Best Answer chosen by lincy
ManojjenaManojjena
HI Lincy,

You can add like below 

TEXT(StageName ) !='initiated' && ISBLANK(TEXT(Type)) &&  (RecordType.DeveloperName='new' ||  RecordType.DeveloperName ='new sales')

new and new Sales should be replaced with record Types developer Name .

Thanks ,
Manoj

All Answers

ManojjenaManojjena
Hi Licy,
Please try with below formula
 
TEXT(StageName ) !='initiated' && ISBLANK(TEXT(Type))

  Remove Type with your next picklist API .

Let us know if it works .

Thanks ,
Manoj
 
lincylincy
Thanks Manojjena for the quick fix.
now i have to include two record types it should work. record type=new and record tpe= new sales 
ManojjenaManojjena
HI Lincy,

You can add like below 

TEXT(StageName ) !='initiated' && ISBLANK(TEXT(Type)) &&  (RecordType.DeveloperName='new' ||  RecordType.DeveloperName ='new sales')

new and new Sales should be replaced with record Types developer Name .

Thanks ,
Manoj
This was selected as the best answer