Hello,
Requesting an update on this post as it is still "pending approval"
Comment actions
Post
Follow
Calculated fields based on values
Hello,
I need to create a calculated field that is based off of a multi select picklist field and cannot seem to do so correctly. The behavior should be as follows.
Field 1: Multi select picklist with 5 values: Value 1, Value 2, Value 3, etc
Field 2: Calculated field based on the selection of those values.
For example: Value 1 is worth 10, Value 2 is worth 7, Value 3 is worth 5.
If value 1&2 is selected, Field 2 should say 17 (10+7). If Only Value 3 is selected, Field 2 should show 5. If Values 1, 2, 3 are selected, it should show 22 (10+7+5)
Any guidance on how to go about this? The creation of intermediary fields is also a possibility that I have not explored.
Please sign in to leave a comment.
2 comments
Date
Votes
You would have to do this using normal picklists as opposed to multi-select. What you can do is have multiple picklists referencing the same object so that you can select more than one and have the values aggregated. Would be curious to learn more about the use case since there might be another way to execute this.
Comment actions