+ Start a Discussion
Lukasz PiziakLukasz Piziak 

Help with IF AND BEGINS formula

Hi,
I'm looking for help with creating a formula for multiple values, see sample below

IF (BEGINS(Name, "572") AND (BEGINS(Fitting_Style_Name__c,"FLARESEAL", "FS","")

 IF (BEGINS(Name, "573") AND (BEGINS(Fitting_Style_Name__c,"TEFLOK", "TL","")

Many thanks for help
Best Answer chosen by Lukasz Piziak
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Lukasz,

Can you check the below formula.
 
IF (AND(BEGINS(Name, "572"), (BEGINS( Fitting_Style_Name__c ,"FLARESEAL"))), "FS", IF (AND(BEGINS(Name, "573") ,(BEGINS(Fitting_Style_Name__c,"TEFLOK"))), "TL",""))

If this solution helps, Please mark it as best answer.

Thanks,

 

All Answers

Lukasz PiziakLukasz Piziak
Name & Fitting_Style_Name__c are TEXT fields
Thanks
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Lukasz,

Can you let the experts know what exactly is required. Do you want to combine both the formulas or are you facing any issue with the formula.

Thanks,
 
Lukasz PiziakLukasz Piziak
Hi Sai,
I would like to combine both formulas

Thanks
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Lukasz,

Can you check the below formula.
 
IF (AND(BEGINS(Name, "572"), (BEGINS( Fitting_Style_Name__c ,"FLARESEAL"))), "FS", IF (AND(BEGINS(Name, "573") ,(BEGINS(Fitting_Style_Name__c,"TEFLOK"))), "TL",""))

If this solution helps, Please mark it as best answer.

Thanks,

 
This was selected as the best answer
Lukasz PiziakLukasz Piziak
Thanks Sai
hsd dsadfhsd dsadf
Thanks for sharing this track formula for a shopping websites. I will surely try this on my oxfords store (https://brunomarcshoes.com/collections/oxfords).