Lead Scoring / Formula Fields

[Nicole_Woodley]

I need to create a Logic as follows: Example: Field: CCVE Behaviour Score Field: CCVE Demographic Score Field: CCVE Lead Score I want to do the following: IF CCVE Behaviour Score greater than 100 AND IF CCVE Demographic Score greater than 100 Give the CCVE Lead Score Field the Value: B3

[Matt_Tonkin-RP]

One way you could accomplish this if the LetterNumber rank is likely to change often is using a segment and then a smart campaign to adjust the field value.

So you apply the correct scores for each segment rank (assuming A-D and 1-4 or something like this) then have a trigger smart campaign on the segment change that populates the Lead Score.

[Nicole_Woodley]

Thank you for that Idea I will try this.

[SanfordWhiteman]

As written, this simply sounds like 2 AND filters in a Smart List. Wouldn't appear to need a segmentation.  If anything, the filters available in a segment's Smart List are more restrictive than the filters you get in a standard batch campaign.