Airtable Formula for Customer Lead Scoring
2026-03-18
Basic Lead Score
Assign points based on company size, engagement, and budget. Each field is a number 1-10:
{Company Size Score} * 0.3 + {Engagement Score} * 0.4 + {Budget Score} * 0.3Lead Priority
Categorize leads as Hot, Warm, or Cold based on score:
IF({Lead Score} >= 8, "Hot", IF({Lead Score} >= 5, "Warm", "Cold"))Days Since Last Contact
Track how stale a lead is:
DATETIME_DIFF(TODAY(), {Last Contact Date}, 'days')Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free