You need to sign in to do that
Don't have an account?
Funkie
ISNULL and multi-select
I created both a multi-select picklist and a formula field to pull values from the multi-select picklist.
My formula is: IF(ISNULL( Software_Version__C), 0 , Software_Version__C)
However, I get an error saying: "Error" Software_Version__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions" with a link to the functions which show:
Multi-select picklist fields can only be used in the following functions:
- INCLUDES
- ISBLANK
- ISNULL
- ISCHANGED (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the trigger type is set to Every time a record is created or edited)
- PRIORVALUE (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the trigger type is set to Every time a record is created or edited)
Any suggestions???
You're trying to return the multi-picklist (from what I can see) as the result in what I can only assume is a text formula data type which won't allow it, you will need a nested if statement for the else result that runs through each value in the multi-picklist and lists it out as a text value.
The above is a bit complicated to do however, if I recall this on Tuesday when I am back I will have a go at a sample of it otherwise if one of the other Dev Board guys can answer, fire away.
I too could use your sample if you get a chance.
Thanks!
Just as an example: (Validation rule usage)
You could replace the 1 or 0 with each picklist value and have an if for each value thus outputting each value into a formula field/field update etc.
I'll give it a try. thanks