You need to sign in to do that
Don't have an account?
Anna Sliwa
Formula IF
Hi
I am trying to create a formula on Contact object called Relation which should show me who is a Member(has activated contract) and who is Not a Member(if haven't got contract at all or contract is lapsed). I have created look up field to Client object and I have written this formula:
IF(ISPICKVAL(Client__r.Type__c, 'Member'),'Member' , 'Non-Member')
Type__c is a picklist field on Client object.
unfortunately on all contacts Relation field showing up Member even there where a contact doesn't have contract (is not a client). What am I doing wrong?
The formula looks good and this is working as expected when I tried from my end.
Make sure you select the appropriate account and client lookup field on contact detail page.
Thanks,