You need to sign in to do that
Don't have an account?
Florian Reissner
Lead assignment, Compare with array
Hi All,
I am trying to implement a Formula for auto lead assignment that does the following in a more efficient way:
IF(Round_Robin_ID__c = 1 || Round_Robin_ID__c = 3 || Round_Robin_ID__c = 6 ....)
Basically I have an array of numbers that I want to compare the Round_Robin_ID against. Ideally it would look like:
IF(ISINARRAY(Round_Robin_ID__c,[1,3,4,6,7,9,.....])
Does anyone know a smart solution to this?
Thank you!
I am trying to implement a Formula for auto lead assignment that does the following in a more efficient way:
IF(Round_Robin_ID__c = 1 || Round_Robin_ID__c = 3 || Round_Robin_ID__c = 6 ....)
Basically I have an array of numbers that I want to compare the Round_Robin_ID against. Ideally it would look like:
IF(ISINARRAY(Round_Robin_ID__c,[1,3,4,6,7,9,.....])
Does anyone know a smart solution to this?
Thank you!
Try the below code :
Best Regards,
Satya.
Easiest way that i might try would create a new picklist column and then compare it with value of picklist using formula
ISPICKVAL(picklist_field, text_literal)
Checks whether the value of a picklist field is equal to a string literal.
Hope this might help you.
Regards,
Jigna
And this is what SF makes it look like:
I want to reproduce the same thing with Apex