You need to sign in to do that
Don't have an account?
N. Weidman
Can anyone help with clearing up the error?
Converting Process to a Formula field with a syntax error
I am working with cleaning up a lot of legacy things in an org I recently came into. In one case, there is a process that I think will work just as well, if not better, as a regular formula field. However, copying over the formula in it, I am getting a Syntax error. Missing '='
Here is the formula:
IF( OR( ISPICKVAL([Account].CS_Relationship_Health_Score__c, "Red"), ISPICKVAL([Account].CS_Adoption_Health_Score__c , "Red"), ISPICKVAL([Account].CS_Product_Health_Score__c , "Red"), ISPICKVAL([Account].CS_Services_Health_Score__c , "Red"), ISPICKVAL([Account].CS_Support_Health_Score__c , "Red") ) , "Red", IF( OR( ISPICKVAL([Account].CS_Relationship_Health_Score__c, "Yellow"), ISPICKVAL([Account].CS_Adoption_Health_Score__c , "Yellow"), ISPICKVAL([Account].CS_Product_Health_Score__c , "Yellow"), ISPICKVAL([Account].CS_Services_Health_Score__c , "Yellow"), ISPICKVAL([Account].CS_Support_Health_Score__c , "Yellow") ) , "Yellow", "Green" ) )
Can anyone help with clearing up the error?
[Account].CS_Relationship_Health_Score__c ==> No need of [Account] in formula field.
In formula field you have to change the formula like below:
Thanks,
Maharajan.C
All Answers
Can you let us know what you are trying to acheive using above formula along with object details ?
Thanks,
[Account].CS_Relationship_Health_Score__c ==> No need of [Account] in formula field.
In formula field you have to change the formula like below:
Thanks,
Maharajan.C
Well, I couldn't leave well enough alone...
The picklists that the above was referencing were themselves updated by a DIFFERENT process. Using your formula as an example, I was able to update all of them to formula fields instead and eliminate that process. However, that means the above no longer references picklist values, but rather text in a formula field. I've tried a couple of different things, but I still keep getting syntax errors. This is what I started with:
I also attempted:
Could I trouble you again for clarification?prepaidcardstatus (https://www.prepaidcardstatus.org/)