# Lead Scoring by Calculating Multi Select Field Value Rollups

Solved
971 2
cancel
Showing results for
Did you mean:
7 - App Architect

I am looking to score my leads in my Airtable which I use as a CRM. I have a multi select field called 'Journey' which has a number of events in the lead life cycle - for example an IOI (indicator of interest) of the prospect asking about the price, or the timelines - what I would like to do is rollup those Journey steps which are in the 'Touchpoints' table and have a lookup field for the Contact into a Contact rollup field and calculate the lead score which would involve assigning unique values to the Journey steps. For example an IOI - Pricing might be 5 points, an IOI - Timelines - might be 7 points (as an example) - adding all those points together and having a lead score. Hope that makes sense.

Any input of how to make a formula like this would be much appreciated.

Video below for reference also:

https://share.getcloudapp.com/yAuAwJdW

1 Solution

Accepted Solutions
18 - Pluto

You'll need to create a formula field that translates the multiple select field options into the appropriate points, and then sum everything up:

``````IF(
FIND(
"IOI - Pricing", {Multiple Select}
),
5,
0
) +
IF(
FIND(
"IOI - Timelines", {Multiple Select}
),
7,
0
)``````
2 Replies 2
18 - Pluto

You'll need to create a formula field that translates the multiple select field options into the appropriate points, and then sum everything up:

``````IF(
FIND(
"IOI - Pricing", {Multiple Select}
),
5,
0
) +
IF(
FIND(
"IOI - Timelines", {Multiple Select}
),
7,
0
)``````
7 - App Architect

Thank you so much!!