I need to field(read only) Field1 that auto populates in the following way:
Field1 = Sum of number of Field2 selected *Field3
Where Field2 is a multiselect. I know this can be done through triggers where I can count how many values of Field2 selected. I was however curious to know if, instead ,i can use a formula field to achieve this. As the multiselect values are stored in colon separated format, so if salesforce provides the options of counting the number of colons in a formula field, my task would become easier.