I want these fields in the new formula as long as the inactive fields are not checked: npe01__One2OneContact__r.FirstName & npe01__One2OneContact__r.Spouse_Name__c . I did the formal greeting and it worked:
IF( npe01__One2OneContact__r.Inactive_Him__c , '', text(npe01__One2OneContact__r.Salutation) & " ") &
IF( OR(text(npe01__One2OneContact__r.Spouse_Salutation__c)='', npe01__One2OneContact__r.Inactive_Her__c ) ,"", IF( OR(npe01__One2OneContact__r.Inactive_Him__c,text(npe01__One2OneContact__r.Salutation) = '') , text(npe01__One2OneContact__r.Spouse_Salutation__c)&" ", " & "&text(npe01__One2OneContact__r.Spouse_Salutation__c)&" ") )
&
npe01__One2OneContact__r.LastName
