Skip to main content
4 of 4
Formating formula for readability
Derek F
  • 64.1k
  • 15
  • 55
  • 104

Validation rule - Salesforce CPQ Contracted checkbox

I want to write a validation rule on the Opportunity record - Condition:- User can only check the contracted checkbox if the opportunity stage is closed won and primary quote (lookup field) - status field is approved. Can someone help me.

I wrote this, but this doesn't work

AND(
    SBQQ__Contracted__c = TRUE,
    TEXT(StageName) <> "Closed",
    TEXT(SBQQ__PrimaryQuote__r.SBQQ__Status__c) <> "Approved"
)

If I consider only opp stagename as condition - it works.. but once I add the primary quote condition my logic fails