Hello, I'm looking to build a lead scoring formula based on U.S. State. I have analysed my historic data and was able to give a score to each state based on how viable a lead is likely to close.
Below is an example of some of the scores I've created:
State Score
CA 6
TX 10
NY 7
FL 3
GA 1
IL 8
NC 8
PA 7
NA 5
OH 2
VA 4
MI 5
SD 8
I believe it should be a case formula, I’m wanting to assign each of the 50 states with correct value in as efficient a way as possible.
Would anyone be able to help with the template?
2 answers
Hi GladMan,Yes , We can use Case in the above scenerio. As the formula maximum length can be around 3900 characters it may not need those many characters for 50 states. The formula can be somethinf as below.
If this solution helps, Please mark it as best answer.Thanks,CASE( State__c ,'CA',6,'TX',10,'NY',7,'FL',3,1)
