2

I am trying to make a formula that will give values from a multi-select picklist and i want to know what is the fastest and cleanest way to do this?

Video_Monetizing_tool__c != "No" to give a value of 10. This means everything that is else in the picklist should be with value of 10 except No should be 0.

IF i do Case(Video_Monetizing_tool__c , "No","0" , "YES", "10", "Maybe", "10", "Often","10","null") this will pass only the values that are set up but what if i select multiple values?

Please advise, Darko

2
  • One of the many reasons that Multiselect picklists kind of suck. Do you want the values to be additive? Ie, does Yes + Maybe = 20? What happens if No and another value are selected? Commented Nov 21, 2014 at 14:16
  • Hi @ThomasTaylor. The values should with combinations. YES + MAYBE=10 , YES + MAYBE+Often=10, YES + Often=10. ALl combinations give 10 except No gives 0. Commented Nov 21, 2014 at 14:23

1 Answer 1

4

What about this?

if(ISBLANK(Video_Monetizing_tool__c),NULL,IF(INCLUDES(Video_Monetizing_tool__c,'No'),0,10))
1
  • you are a genius ! This works ! Commented Nov 21, 2014 at 15:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .