function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
broncobronco 

Formula to duplicate checkbox state on Lookup record

I have a Lookup field on a Contact record called Spouse__c. It enables me to add a link to another Contact to the Contact record. We manually reciprocate so both Contacts have their related spouse.
I also have a Deceased__c checkbox.  I am trying to indicate on Spouse 1 if Spouse 2 has the Deceased checkbox checked.

IF(Spouse__r.Deceased__c,'',
TEXT(SpouseDeceased)
)

But this doesn't work.
Best Answer chosen by bronco
PrabhaPrabha
Oh, if thats the case, you can dynamically change the return type of the field back to 'text' with a small correction in your formula as follows:

IF(Spouse__r.Deceased__c,'',
'Spouse Deceased'
)

All Answers

PrabhaPrabha
You shoulld be able to do that.

Create a formula with return type checkbox and use this formula "Spouse__r.Deceased__c". (No IFs , No BUTs ;)  )

It replicates what ever is there on the related object (contact, in ur case!?!).
broncobronco
Thank you. I was trying to get the field to display a message, but have settled for a checkbox and this works fine. Thanks.
PrabhaPrabha
Oh, if thats the case, you can dynamically change the return type of the field back to 'text' with a small correction in your formula as follows:

IF(Spouse__r.Deceased__c,'',
'Spouse Deceased'
)
This was selected as the best answer