
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2023 01:50 PM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 12:35 AM
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
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 12:35 AM
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
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 01:40 AM
Thank you so much!!
