Sign Up ›
  • Florian Reissner
  • NEWBIE
  • 0 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
5 replies

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!
5 replies

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!