Wondering if anyone could help me out. My text formula field is not firing the way I want it to.
The Error that is happening is currently on my object and the market value is "Professional / Trade Association" and Annual Revenue is greater than 5,000,000. It should be firing "Assoc Enterprise" but it's firing "Unassigned Segment". Please help
Here is the formula:
IF( OR( TEXT( Market__c ) <> "Professional / Trade Association" ,TEXT( Market__c ) <> "Corporate / For Profit") , "Unassigned Segment",
IF( AND( ISPICKVAL( Market__c , "Professional / Trade Association") , AnnualRevenue >= 5000000 ) , "Assoc Enterprise",
IF( AND(ISPICKVAL( Market__c , "Professional / Trade Association") , AnnualRevenue < 5000000) , "Assoc SMB",
IF( AND( ISPICKVAL( Market__c , "Corporate / For Profit") , AnnualRevenue >= 50000000) , "Corporate Enterprise",
IF( AND( ISPICKVAL( Market__c , "Corporate / For Profit") , AnnualRevenue < 50000000) , "Corporate SMB", "this is where the error is") ) ) ) )
Here is the description of my formula:
If the market field is professional/trade association and annual revenue is greater than or equal to $5M than the Segment is Assoc Enterprise. If it's less than $5M than the Segment is Assoc SMB.
If the market field is Corporate/For profit and the annual revenue is greater than or equal $50M than the Segment is Corporate Enterprise. If it's less than $50M it's Corporate SMB.
If the Market field does not equal either Professional/Trade Association or Corporate/For Profit than the Sales Segment is Unassigned Segment.
4 answers
Thanks guys the issue was with the picklist. Someone had changed the API name so I was referencing the wrong thing using ispickval formula
