Skip to main content
Formatting for readability
Source Link
Derek F
  • 64k
  • 15
  • 54
  • 104

I am trying to create a formula field that looks at two fields to determine the result in the formula field. see below my logic;

If field Status = "Ruled Out" and the field Ruled Out Reason = "Wants to sell" or "Agent" or "Fund" then the result in the formula field should read "Unacceptable". I have created the logic below but it does not work. Can anyone please help with this ??

IF( AND(ISPICKVAL (pba__Status__c,"Ruled Out"),ISPICKVAL(Ruled_Out_Reason__c, ("Wants to sell property"OR"Agent"OR"fund")),"Unacceptable","")

IF(
    AND(
        ISPICKVAL (pba__Status__c,"Ruled Out"),
        ISPICKVAL(Ruled_Out_Reason__c, ("Wants to sell property"OR"Agent"OR"fund")
    ),
    "Unacceptable",
    ""
)

I am trying to create a formula field that looks at two fields to determine the result in the formula field. see below my logic;

If field Status = "Ruled Out" and the field Ruled Out Reason = "Wants to sell" or "Agent" or "Fund" then the result in the formula field should read "Unacceptable". I have created the logic below but it does not work. Can anyone please help with this ??

IF( AND(ISPICKVAL (pba__Status__c,"Ruled Out"),ISPICKVAL(Ruled_Out_Reason__c, ("Wants to sell property"OR"Agent"OR"fund")),"Unacceptable","")

I am trying to create a formula field that looks at two fields to determine the result in the formula field. see below my logic;

If field Status = "Ruled Out" and the field Ruled Out Reason = "Wants to sell" or "Agent" or "Fund" then the result in the formula field should read "Unacceptable". I have created the logic below but it does not work. Can anyone please help with this ??

IF(
    AND(
        ISPICKVAL (pba__Status__c,"Ruled Out"),
        ISPICKVAL(Ruled_Out_Reason__c, ("Wants to sell property"OR"Agent"OR"fund")
    ),
    "Unacceptable",
    ""
)
Source Link

Formula field logic

I am trying to create a formula field that looks at two fields to determine the result in the formula field. see below my logic;

If field Status = "Ruled Out" and the field Ruled Out Reason = "Wants to sell" or "Agent" or "Fund" then the result in the formula field should read "Unacceptable". I have created the logic below but it does not work. Can anyone please help with this ??

IF( AND(ISPICKVAL (pba__Status__c,"Ruled Out"),ISPICKVAL(Ruled_Out_Reason__c, ("Wants to sell property"OR"Agent"OR"fund")),"Unacceptable","")