Skip to main content

I'm trying to make a field (Total Billable Hours) required when the opportunity stages are Scoping, Proposal, Pending Signature or Closed Won. I'm getting a syntax error. Can somebody help me with the formula?

 

AND ( 

OR ( 

 ISPICKVAL(StageName, "Scoping"),

 ISPICKVAL(StageName, "Proposal"),

 ISPICKVAL(StageName, "Pending Signature"),

 ISPICKVAL(StageName, "Closed Won"))),

ISNULL( Total_Billable_Hours__c ))

2 Antworten
  1. 21. März 2024, 17:36

    Hi @Kyle Sullivan

    Seems like you have extra closing parentheses after the OR function

    AND (

    OR (

    ISPICKVAL(StageName, "Scoping"),

    ISPICKVAL(StageName, "Proposal"),

    ISPICKVAL(StageName, "Pending Signature"),

    ISPICKVAL(StageName, "Closed Won")

    ),

    ISNULL(Total_Billable_Hours__c)

    )