• Taylor Figge 10
  • NEWBIE
  • -2 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 5
    Replies
I've created this field formula, but it exceeds the character limit. can anyone help me reduce the characters?

IF( AND( Industry ="Agriculture", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Agriculture", Emp_Range__c ="5-9"),"1.0"),IF( AND( Industry ="Agriculture", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Agriculture", Emp_Range__c ="25-49"),"1.5"),IF( AND( Industry ="Agriculture", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Agriculture", Emp_Range__c ="100-249"),"2.6"),IF( AND( Industry ="Agriculture", Emp_Range__c ="250+"),"3.0"), IF( AND( Industry ="Banking", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Banking", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Banking", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Banking", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Banking", Emp_Range__c ="50-99"),"2.9"),IF( AND( Industry ="Banking", Emp_Range__c ="100-249"),"3.4"),IF( AND( Industry ="Banking", Emp_Range__c ="250+"),"6.2"),IF( AND( Industry ="Construction", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Construction", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Construction", Emp_Range__c ="10-24"),"1.3"),IF( AND( Industry ="Construction", Emp_Range__c ="25-49"),"1.4"),IF( AND( Industry ="Construction", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Construction", Emp_Range__c ="100-249"),"2.2"),IF( AND( Industry ="Construction", Emp_Range__c ="250+"),"4.1"),IF( AND( Industry ="Consulting", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Consulting", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Consulting", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Consulting", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Consulting", Emp_Range__c ="50-99"),"2.0"),IF( AND( Industry ="Consulting", Emp_Range__c ="100-249"),"3.0"),IF( AND( Industry ="Consulting", Emp_Range__c ="250+"),"5.0"),IF( AND( Industry ="Education", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Education", Emp_Range__c ="5-9"),"1.5"),IF( AND( Industry ="Education", Emp_Range__c ="10-24"),"1.7"),IF( AND( Industry ="Education", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Education", Emp_Range__c ="50-99"),"3.2"),IF( AND( Industry ="Education", Emp_Range__c ="100-249"),"4.3"),IF( AND( Industry ="Education", Emp_Range__c ="250+"),"5.0"),IF( AND( Industry ="Energy", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Energy", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Energy", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Energy", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Energy", Emp_Range__c ="50-99"),"3.0"),IF( AND( Industry ="Energy", Emp_Range__c ="100-249"),"3.7"),IF( AND( Industry ="Energy", Emp_Range__c ="250+"),"6.7"),IF( AND( Industry ="Engineering", Emp_Range__c ="1-4"),"1.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Engineering", Emp_Range__c ="25-49"),"1.6"),IF( AND( Industry ="Engineering", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Engineering", Emp_Range__c ="100-249"),"3.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="250+"),"6.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="5-9"),"1.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Entertainment", Emp_Range__c ="25-49"),"1.4"),IF( AND( Industry ="Entertainment", Emp_Range__c ="50-99"),"1.9"),IF( AND( Industry ="Entertainment", Emp_Range__c ="100-249"),"2.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="250+"),"3.8"),IF( AND( Industry ="Finance", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Finance", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Finance", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Finance", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Finance", Emp_Range__c ="50-99"),"3.5"),IF( AND( Industry ="Finance", Emp_Range__c ="100-249"),"3.7"), IF( AND( Industry ="Finance", Emp_Range__c ="250+"),"4.0"), IF( AND( Industry ="Government", Emp_Range__c ="1-4"),"1.6"),IF( AND( Industry ="Government", Emp_Range__c ="5-9"),"2.0"),IF( AND( Industry ="Government", Emp_Range__c ="10-24"),"2.2"),IF( AND( Industry ="Government", Emp_Range__c ="25-49"),"2.9"),IF( AND( Industry ="Government", Emp_Range__c ="50-99"),"3.1"),IF( AND( Industry ="Government", Emp_Range__c ="100-249"),"3.3"), IF( AND( Industry ="Government", Emp_Range__c ="250+"),"4.0"), IF( AND( Industry ="Healthcare", Emp_Range__c ="1-4"),"1.3"),IF( AND( Industry ="Healthcare", Emp_Range__c ="5-9"),"1.5"),IF( AND( Industry ="Healthcare", Emp_Range__c ="10-24"),"1.6"),IF( AND( Industry ="Healthcare", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Healthcare", Emp_Range__c ="50-99"),"2.7"),IF( AND( Industry ="Healthcare", Emp_Range__c ="100-249"),"2.8"), IF( AND( Industry ="Healthcare", Emp_Range__c ="250+"),"8.5"), IF( AND( Industry ="Hospitality", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Hospitality", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Hospitality", Emp_Range__c ="10-24"),"1.7"),IF( AND( Industry ="Hospitality", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Hospitality", Emp_Range__c ="50-99"),"3.9"),IF( AND( Industry ="Hospitality", Emp_Range__c ="100-249"),"4.2"), IF( AND( Industry ="Hospitality", Emp_Range__c ="250+"),"4.5"), IF( AND( Industry ="Insurance", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Insurance", Emp_Range__c ="5-9"),"1.4"),IF( AND( Industry ="Insurance", Emp_Range__c ="10-24"),"1.6"),IF( AND( Industry ="Insurance", Emp_Range__c ="25-49"),"2.6"),IF( AND( Industry ="Insurance", Emp_Range__c ="50-99"),"3.0"),IF( AND( Industry ="Insurance", Emp_Range__c ="100-249"),"4.0"), IF( AND( Industry ="Insurance", Emp_Range__c ="250+"),"14.0"), IF( AND( Industry ="Manufacturing", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="25-49"),"1.7"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="100-249"),"2.6"), IF( AND( Industry ="Manufacturing", Emp_Range__c ="250+"),"3.0"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="50-99"),"3.4"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="100-249"),"4.5"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="250+"),"5.0"), IF( AND( Industry ="Other", Emp_Range__c ="1-4"),"1,2"),IF( AND( Industry ="Other", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Other", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Other", Emp_Range__c ="25-49"),"1.8"),IF( AND( Industry ="Other", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Other", Emp_Range__c ="100-249"),"2.7"), IF( AND( Industry ="Other", Emp_Range__c ="250+"),"4.7"), IF( AND( Industry ="Retail", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Retail", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Retail", Emp_Range__c ="10-24"),"1.3"),IF( AND( Industry ="Retail", Emp_Range__c ="25-49"),"1.6"),IF( AND( Industry ="Retail", Emp_Range__c ="50-99"),"1.6"),IF( AND( Industry ="Retail", Emp_Range__c ="100-249"),"2.3"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="250+"),"5.6"), IF( AND( Industry ="Transportation", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Transportation", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Transportation", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Transportation", Emp_Range__c ="25-49"),"1.5"),IF( AND( Industry ="Transportation", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Transportation", Emp_Range__c ="100-249"),"2.3"), IF( AND( Industry ="Transportation", Emp_Range__c ="250+"),"2.8"),””))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
 
I've created this field formula, but it exceeds the character limit. can anyone help me reduce the characters?

IF( AND( Industry ="Agriculture", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Agriculture", Emp_Range__c ="5-9"),"1.0"),IF( AND( Industry ="Agriculture", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Agriculture", Emp_Range__c ="25-49"),"1.5"),IF( AND( Industry ="Agriculture", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Agriculture", Emp_Range__c ="100-249"),"2.6"),IF( AND( Industry ="Agriculture", Emp_Range__c ="250+"),"3.0"), IF( AND( Industry ="Banking", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Banking", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Banking", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Banking", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Banking", Emp_Range__c ="50-99"),"2.9"),IF( AND( Industry ="Banking", Emp_Range__c ="100-249"),"3.4"),IF( AND( Industry ="Banking", Emp_Range__c ="250+"),"6.2"),IF( AND( Industry ="Construction", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Construction", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Construction", Emp_Range__c ="10-24"),"1.3"),IF( AND( Industry ="Construction", Emp_Range__c ="25-49"),"1.4"),IF( AND( Industry ="Construction", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Construction", Emp_Range__c ="100-249"),"2.2"),IF( AND( Industry ="Construction", Emp_Range__c ="250+"),"4.1"),IF( AND( Industry ="Consulting", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Consulting", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Consulting", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Consulting", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Consulting", Emp_Range__c ="50-99"),"2.0"),IF( AND( Industry ="Consulting", Emp_Range__c ="100-249"),"3.0"),IF( AND( Industry ="Consulting", Emp_Range__c ="250+"),"5.0"),IF( AND( Industry ="Education", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Education", Emp_Range__c ="5-9"),"1.5"),IF( AND( Industry ="Education", Emp_Range__c ="10-24"),"1.7"),IF( AND( Industry ="Education", Emp_Range__c ="25-49"),"1.9"),IF( AND( Industry ="Education", Emp_Range__c ="50-99"),"3.2"),IF( AND( Industry ="Education", Emp_Range__c ="100-249"),"4.3"),IF( AND( Industry ="Education", Emp_Range__c ="250+"),"5.0"),IF( AND( Industry ="Energy", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Energy", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Energy", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Energy", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Energy", Emp_Range__c ="50-99"),"3.0"),IF( AND( Industry ="Energy", Emp_Range__c ="100-249"),"3.7"),IF( AND( Industry ="Energy", Emp_Range__c ="250+"),"6.7"),IF( AND( Industry ="Engineering", Emp_Range__c ="1-4"),"1.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Engineering", Emp_Range__c ="25-49"),"1.6"),IF( AND( Industry ="Engineering", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Engineering", Emp_Range__c ="100-249"),"3.3"),IF( AND( Industry ="Engineering", Emp_Range__c ="250+"),"6.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="5-9"),"1.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Entertainment", Emp_Range__c ="25-49"),"1.4"),IF( AND( Industry ="Entertainment", Emp_Range__c ="50-99"),"1.9"),IF( AND( Industry ="Entertainment", Emp_Range__c ="100-249"),"2.0"),IF( AND( Industry ="Entertainment", Emp_Range__c ="250+"),"3.8"),IF( AND( Industry ="Finance", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Finance", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Finance", Emp_Range__c ="10-24"),"1.5"),IF( AND( Industry ="Finance", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Finance", Emp_Range__c ="50-99"),"3.5"),IF( AND( Industry ="Finance", Emp_Range__c ="100-249"),"3.7"), IF( AND( Industry ="Finance", Emp_Range__c ="250+"),"4.0"), IF( AND( Industry ="Government", Emp_Range__c ="1-4"),"1.6"),IF( AND( Industry ="Government", Emp_Range__c ="5-9"),"2.0"),IF( AND( Industry ="Government", Emp_Range__c ="10-24"),"2.2"),IF( AND( Industry ="Government", Emp_Range__c ="25-49"),"2.9"),IF( AND( Industry ="Government", Emp_Range__c ="50-99"),"3.1"),IF( AND( Industry ="Government", Emp_Range__c ="100-249"),"3.3"), IF( AND( Industry ="Government", Emp_Range__c ="250+"),"4.0"), IF( AND( Industry ="Healthcare", Emp_Range__c ="1-4"),"1.3"),IF( AND( Industry ="Healthcare", Emp_Range__c ="5-9"),"1.5"),IF( AND( Industry ="Healthcare", Emp_Range__c ="10-24"),"1.6"),IF( AND( Industry ="Healthcare", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Healthcare", Emp_Range__c ="50-99"),"2.7"),IF( AND( Industry ="Healthcare", Emp_Range__c ="100-249"),"2.8"), IF( AND( Industry ="Healthcare", Emp_Range__c ="250+"),"8.5"), IF( AND( Industry ="Hospitality", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Hospitality", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Hospitality", Emp_Range__c ="10-24"),"1.7"),IF( AND( Industry ="Hospitality", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Hospitality", Emp_Range__c ="50-99"),"3.9"),IF( AND( Industry ="Hospitality", Emp_Range__c ="100-249"),"4.2"), IF( AND( Industry ="Hospitality", Emp_Range__c ="250+"),"4.5"), IF( AND( Industry ="Insurance", Emp_Range__c ="1-4"),"1.0"),IF( AND( Industry ="Insurance", Emp_Range__c ="5-9"),"1.4"),IF( AND( Industry ="Insurance", Emp_Range__c ="10-24"),"1.6"),IF( AND( Industry ="Insurance", Emp_Range__c ="25-49"),"2.6"),IF( AND( Industry ="Insurance", Emp_Range__c ="50-99"),"3.0"),IF( AND( Industry ="Insurance", Emp_Range__c ="100-249"),"4.0"), IF( AND( Industry ="Insurance", Emp_Range__c ="250+"),"14.0"), IF( AND( Industry ="Manufacturing", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="25-49"),"1.7"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Manufacturing", Emp_Range__c ="100-249"),"2.6"), IF( AND( Industry ="Manufacturing", Emp_Range__c ="250+"),"3.0"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="25-49"),"2.3"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="50-99"),"3.4"),IF( AND( Industry ="Not for Profit", Emp_Range__c ="100-249"),"4.5"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="250+"),"5.0"), IF( AND( Industry ="Other", Emp_Range__c ="1-4"),"1,2"),IF( AND( Industry ="Other", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Other", Emp_Range__c ="10-24"),"1.4"),IF( AND( Industry ="Other", Emp_Range__c ="25-49"),"1.8"),IF( AND( Industry ="Other", Emp_Range__c ="50-99"),"2.2"),IF( AND( Industry ="Other", Emp_Range__c ="100-249"),"2.7"), IF( AND( Industry ="Other", Emp_Range__c ="250+"),"4.7"), IF( AND( Industry ="Retail", Emp_Range__c ="1-4"),"1.2"),IF( AND( Industry ="Retail", Emp_Range__c ="5-9"),"1.3"),IF( AND( Industry ="Retail", Emp_Range__c ="10-24"),"1.3"),IF( AND( Industry ="Retail", Emp_Range__c ="25-49"),"1.6"),IF( AND( Industry ="Retail", Emp_Range__c ="50-99"),"1.6"),IF( AND( Industry ="Retail", Emp_Range__c ="100-249"),"2.3"), IF( AND( Industry ="Not for Profit", Emp_Range__c ="250+"),"5.6"), IF( AND( Industry ="Transportation", Emp_Range__c ="1-4"),"1.1"),IF( AND( Industry ="Transportation", Emp_Range__c ="5-9"),"1.2"),IF( AND( Industry ="Transportation", Emp_Range__c ="10-24"),"1.2"),IF( AND( Industry ="Transportation", Emp_Range__c ="25-49"),"1.5"),IF( AND( Industry ="Transportation", Emp_Range__c ="50-99"),"2.1"),IF( AND( Industry ="Transportation", Emp_Range__c ="100-249"),"2.3"), IF( AND( Industry ="Transportation", Emp_Range__c ="250+"),"2.8"),””))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
 

Hi,

 

Is it possible to concatenate 2 fields and then set this as a value of a different field.

 

for example:

 

Field1__c = Field2__c + Field3__c

 

Is this possible??

 

Thanks in advance! 

  • November 23, 2011
  • Like
  • 0