I have 2 objects

  1. Contracts - Custom
  2. Sales Submission (Opportunity Process) - Custom

They are related because of Lookup relationship.

GOAL: I want to show in Sales Submission Object that when the Contract Status is Cancelled, the string "Cancelled" should populate in this formula field. This is my formula:

Formula in Sales Submission:

IF ( Ispickval ( Related_Contract_Record__r.Contract_Status__c, 'Cancelled'), 'Cancelled' ,


Expected Result: String "Cancelled" if Contract Status is Cancelled else "NotCancelled" Result: 'NotCancelled' even though the Contract Status is Cancelled.

I also created a Checkbox


IF ( ISPICKVAL ( Related_Contract_Record__r.Contract_Status__c , 'Cancelled' ), TRUE , FALSE )

Result: False, even if Contract Record is Cancelled

  • Regarding the formula field in your first example: It seems that your condition is checking if Contract_Status__c is equal to Active and not equal to "Cancelled" as your description mentioned Feb 5 '20 at 23:43
  • Aw sorry, I did some changes before I posted my question. I'll edit my first formula
    – Xde
    Feb 5 '20 at 23:54
  • I'm just curious if a text formula field of Related_Contract_Record__r.Contract_Status__c isn't enough? Assuming that a String like "Cancelled" or "Not Cancelled" is enough Feb 6 '20 at 0:00
  • I agree, but the formula does not return “Cancelled” string eventough the Contract Status is set to Cancelled....Im not sure why, I have the same formula for other objects but its working perfectly fine.
    – Xde
    Feb 6 '20 at 1:32

I would try this instead:

IF ( TEXT( Related_Contract_Record__r.Contract_Status__c ) == "Cancelled", 

and for your checkbox:

IF ( TEXT( Related_Contract_Record__r.Contract_Status__c ) == 'Cancelled' ), 
    FALSE )

You should see that your formula will then evaluate accordingly. The only time there would be any issue outside of this is if there is no access to the related record, or is not populated. Inaccessible objects would cause this to return false, all the same as if it was not there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.