Getting this error:
Error: Invalid Data.
Review all error messages below to correct your data.
Formula(s) that reference this field are no longer valid: Syntax error. Found 'end of formula'
Saw some posts mentioning that it could be exceeding the character limit, but the syntax check outputs this:
No syntax errors in merge fields or functions. (Compiled size: 2,012 characters)
Account_Type__c is a picklist, so this formula should not have any issues with compounding references to other formulas.
Any ideas on why this isn't working?
Thanks!
Here's the code:
CASE( 1,
IF(ISPICKVAL( Account_Type__c ,'93-Profit Sharing'),1,0), 'Retirement',
IF(ISPICKVAL( Account_Type__c ,'97-Other Retirement Accounts'),1,0), 'Retirement',
IF(ISPICKVAL( Account_Type__c ,'90-IRAs'),1,0), 'Retirement',
IF(ISPICKVAL( Account_Type__c ,'92-Agent - Pension'),1,0), 'Retirement',
IF(ISPICKVAL( Account_Type__c ,'69-IRA'),1,0), 'Retirement',
IF(ISPICKVAL( Account_Type__c ,'41-Revocable - Sole'),1,0), 'Trust',
IF(ISPICKVAL( Account_Type__c ,'43-IRREV - Sole'),1,0), 'Trust',
IF(ISPICKVAL( Account_Type__c ,'45-Term Trust '),1,0), 'Trust',
IF(ISPICKVAL( Account_Type__c ,'31-Trustee U/W'),1,0), 'Trust',
IF(ISPICKVAL( Account_Type__c ,'61-Investment Agency - Sole'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'63-Cemeteries'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'66-Investment Agent for Executor/Administration'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'65-Investment Agency for Trustee'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'62-Partnerships'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'Discretionary Investment Advisory Account'),1,0), 'Agency',
IF(ISPICKVAL( Account_Type__c ,'11-Personal Representative'),1,0), 'Estate',
IF(ISPICKVAL( Account_Type__c ,'12-Co-Personal Representative'),1,0), 'Estate',
IF(ISPICKVAL( Account_Type__c ,'19-Agent for Personal Representative'),1,0), 'Estate',
IF(ISPICKVAL( Account_Type__c ,'71-Custodian, Tax Service, Limited Agent'),1,0), 'Custodial',
IF(ISPICKVAL( Account_Type__c ,'72-Custodian, No Tax Service, Limited Agent'),1,0), 'Custodial',
IF(ISPICKVAL( Account_Type__c ,'75-Escrow'),1,0), 'Custodial',
'')
Attribution to: jackerman09
Possible Suggestion/Solution #1
I know this is super old, but I'd recommend using the CASE function without the IF statements. In looking at the formula, I don't think this will do what you need it to. No matter what the picklist value, you only get a 1 or 0 and so there's bound to be a conflict since all values such as agency, trust, etc are being mapped to both 1 and 0.
Attribution to: Jon Tresko
Possible Suggestion/Solution #2
I tested your Formula in a clean Developer Edition and it works correctly with no errors. This means that its not the new formula that is wrong. To help further can you answer these questions:
- What Formula was in this field before?
- Are there any fields that are based or reference this field from other objects? (Such as a Formula field in the Contact object?)
Attribution to: Jon Hazan
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/507