Lead Scoring by Calculating Multi Select Field Value Rollups

Question

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

TheTimeSavingCo · Accepted Answer

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
)

Thank you so much!!

Kosta_Kondraten · Answer

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
)

Thank you so much!!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded