function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Phillip Moseley 2Phillip Moseley 2 

Need help with formula field that will show text value based off number range of field. So if value is >=0 and <=1 then Laggard would be the text value in field

Here are several examples that I've tried and can't get them to work. Any help would be appreciated to get either one of these working or if there is another easier way to write the formula.

Thanks,

Example 1:
IF(ePro_ROI_Soft_Hard_Rank__c >= 0  || <= 1,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c > 1  || <= 2,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 2  || <= 3,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c > 3  || <= 4,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 4  || <= 5,"Best in Class"
)
)
)
)
)

Example 2:
IF(ePro_ROI_Soft_Hard_Rank__c >= 0,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c <= 1,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c > 1,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c <= 2,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 2,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c <= 3,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c > 3,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c <= 4,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 4,"Best in Class",
IF(ePro_ROI_Soft_Hard_Rank__c <= 5,"Best in Class"))))))))))
 
Best Answer chosen by Phillip Moseley 2
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Philip,

Can you try the below formula.
  
if(AND(ePro_ROI_Soft_Hard_Rank__c<=1,ePro_ROI_Soft_Hard_Rank__c>0),'Laggard', 

if(AND(ePro_ROI_Soft_Hard_Rank__c>1,ePro_ROI_Soft_Hard_Rank__c<=2),'Low Performer',

if(AND(ePro_ROI_Soft_Hard_Rank__c>2,ePro_ROI_Soft_Hard_Rank__c<=3),'Average' , if(AND(ePro_ROI_Soft_Hard_Rank__c>3,ePro_ROI_Soft_Hard_Rank__c<=4),'High Performer', 

if(AND(ePro_ROI_Soft_Hard_Rank__c>4,ePro_ROI_Soft_Hard_Rank__c<=5),'Best in Class','')
))

))

Let me know if you face any issues.

If this solution helps, Please mark it as best answer.

Thanks,

All Answers

Balaji Vadlamudi 5Balaji Vadlamudi 5
Try this. You might have to make minor adjustments.
  
If (ePro_ROI_Soft_Hard_Rank__c >=4, "Best in Class", 
If (ePro_ROI_Soft_Hard_Rank__c >=3, "High Performer",
If (ePro_ROI_Soft_Hard_Rank__c >=2, "Average",
If (ePro_ROI_Soft_Hard_Rank__c >=1, "Low Performer", "Laggard"))))




 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi,

Can you confirm when to populate "Best in Class" , "High Performer","Average" and "low Performer".

The expression which you wrote is little confusing. Can you confirm your requirement.

Thanks,
 
Phillip Moseley 2Phillip Moseley 2
Hi Sai, here is the criteria. Let me know if this helps or you need more information. Thanks.
  If ePro ROI (Soft + Hard) - Rank is between 0 and 1 (1 included), then display “Laggard”
                If ePro ROI (Soft + Hard) - Rank is between 1 and 2 (1 excluded, 2 included), then display “Low Performer”
                If ePro ROI (Soft + Hard) - Rank is between 2 and 3 (2 excluded, 3 included), then display “Average”
                If ePro ROI (Soft + Hard) - Rank is between 3 and 4 (3 excluded, 4 included), then display “High Performer”
                If ePro ROI (Soft + Hard) - Rank is between 4 and 5 (4 excluded) then display “Best in Class”
 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Philip,

Can you try the below formula.
  
if(AND(ePro_ROI_Soft_Hard_Rank__c<=1,ePro_ROI_Soft_Hard_Rank__c>0),'Laggard', 

if(AND(ePro_ROI_Soft_Hard_Rank__c>1,ePro_ROI_Soft_Hard_Rank__c<=2),'Low Performer',

if(AND(ePro_ROI_Soft_Hard_Rank__c>2,ePro_ROI_Soft_Hard_Rank__c<=3),'Average' , if(AND(ePro_ROI_Soft_Hard_Rank__c>3,ePro_ROI_Soft_Hard_Rank__c<=4),'High Performer', 

if(AND(ePro_ROI_Soft_Hard_Rank__c>4,ePro_ROI_Soft_Hard_Rank__c<=5),'Best in Class','')
))

))

Let me know if you face any issues.

If this solution helps, Please mark it as best answer.

Thanks,
This was selected as the best answer
Phillip Moseley 2Phillip Moseley 2
Thanks so much for the help Sai. This worked great!