I am having an issue writing a checkbox formula field on the Opportunity object.
I am trying to use 2 picklist fields - Type
and Stage
. I need the checkbox value to be true if
Type = NULL, New Business, Paywall, or Reactivation AND Stage - Closed Won
Here is my formula:
IF
( ISPICKVAL(Type,"")||
ISPICKVAL(Type,"New Business")||
ISPICKVAL(Type,"Paywall")||
ISPICKVAL(Type,"Reactivation")&&
ISPICKVAL(StageName,"Closed Won"),TRUE, FALSE)
The syntax check is showing no errors. My issue is that the checkbox is being marked TRUE for any StageName value instead of only Closed Won.
Does anyone know what I am doing wrong?
Thank you so much!