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
Shekhar 13Shekhar 13 

Formulae field with picklist

Hi ! All ,

Please note I want to write a formulae where we have experience more than 10 years then in the field "trainer category" which is a picklist we shave to show platinum 
CharuDuttCharuDutt
Hii Shekhar
Try Below Formula 
Formula Field Data Type (Text)

If(ISPICKVAL(Trainer_Category__c,'10 YEARS','Platinum',Null)
Please Mark it As Best Answer If It Helps
Thank You!
 
Maharajan CMaharajan C
Missing one closing bracket in charu formula.  
If(ISPICKVAL(Trainer_Category__c,'10 YEARS'),'Platinum',Null)

Thanks,
Maharajan.C
Shekhar 13Shekhar 13
Charu & Maharajan,

Please note actually the rule is If the  Trainer experience is more than 15 years than in the field trainer category it should be platinium , & Exp more than 10 years trainer category should be gold , Exp more than 5 years trainer category would be silver , Exp less than 5 years or 5 trainer category would be Bronze.
CharuDuttCharuDutt
Hi Shekhar
Try Below Code 
If(ISPICKVAL(Trainer_Category__c,'15 YEARS'),'Platinum',
If(ISPICKVAL(Trainer_Category__c,'10 YEARS'),'Gold',
If(ISPICKVAL(Trainer_Category__c,'5 YEARS'),'Silver',
If(ISPICKVAL(Trainer_Category__c,'1-4 YEARS'),'Bronze',Null))))
Please Mark it As Best Answer If It Helps
Thank You!
 
Ashalatha SampathAshalatha Sampath
Hi Shekhar 
I used this code

IF( Experience__c >= 15,"PLATINUM",
IF( Experience__c >= 10 && Experience__c < 15,"GOLD",
IF( Experience__c > 5 && Experience__c <10,"SILVER",
IF( Experience__c = 5 , "BRONZE" ,''))))
Ashalatha SampathAshalatha Sampath
I changed the Training Category data type from pick list field to formula field