You need to sign in to do that
Don't have an account?
WPCMS
Formula: case with &&'s
I am trying to create a formula that will show what type of service description our object is.
I know how to do the case for one field:
CASE(text( Waste_Type__c ),"SW","Solid Waste Can","OCC","Cardboard Can","RM","Recyclable Materials Can","")
But I need to take this one step further and have two fields matched to return the complete service description.
In my words:
If waste type = "SW" && can_size_c <10 then return "Solid waste can",
else if waste type = "SW" && can-size_c >10 then return "Solid Waste Roll Off"
Thank you in advance
The code below is what you can use if what you wrote out previously is the logic you are trying to enforce. So you are saying, if waste type is "SW" and Can size is less than 10, the value is "Solid waste can." If waste type is "SW" and Can size is greater than 10, the value is "Solid Waste Roll Off". Otherwise, it is null.
If (ISPICKVAL (Waste_Type__c, "SW") && can_size_c <10, "Solid waste can",
If ISPICKVAL (Waste_Type__c, "SW") && can-size_c >10, "Solid Waste Roll Off", null)
All Answers
I would forego using the CASE function and just write your formula something like this:
If (Waste_Type__c = "SW" && can_size_c <10, "Solid waste can",
If Waste_Type__c = "SW" && can-size_c >10, "Solid Waste Roll Off", null)
If your Waste_Type__c field is a pick list, you'll have to use ISPICKVAL (Waste_Type__c, "SW")
The code below is what you can use if what you wrote out previously is the logic you are trying to enforce. So you are saying, if waste type is "SW" and Can size is less than 10, the value is "Solid waste can." If waste type is "SW" and Can size is greater than 10, the value is "Solid Waste Roll Off". Otherwise, it is null.
If (ISPICKVAL (Waste_Type__c, "SW") && can_size_c <10, "Solid waste can",
If ISPICKVAL (Waste_Type__c, "SW") && can-size_c >10, "Solid Waste Roll Off", null)