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
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)
)