Parent Object - Opportunity
Child Object - Opportunity Product
I have a field for each product on the Opportunity. For example if Opportunity Products X and Y were added to the Opportunity as Opportunity Products on Opportunity fields would state :
1 indicated products was purchased.
I need to create a formula field that would look up each product's field and if the field is 1 return the name of the product and do it in a string. The issue is if multiple products were purchased the string should return all.
Example Product X=1 Product Y=1 Product Z=0 Products W=0
New field Products Purchased = X,Y
I tried to achieve this with IF formulas, but as soon as it evaluated to true it stops checking for other Products. I thought of using the Case formula, but as I understand it works only with retuning numbers.
this is what I have so far, but no idea how to combine it
IF ( Opportunity__r.Product_X >0,"X",
IF( Opportunity__r.Product_Y >0,"Y",
IF( Opportunity__r.Product_Z >0,"Z",