Help with formula field needed

Question

The population of ABC fields depends on field__r.Account__r.Name field.

I want to assigned ABC formula field with field__r.Account__r.Name value if field__r.field__c is blank,

but if there are some values in field__r.field__c then ABC field should be OpportunityName__r.Account.Name value

So I tried this...

IF(ISBLANK(field__r.field__c), OpportunityName__r.Account.Name, field__r.Account__r.Name)

Is it achievable using formula fields? thanks

Hi, you need to provide some more details like.. in which object you are creating this formula field ? how is this object related to opportunity or account object ? is field__c a custom lookup field in your object & why are you using Account__r & OpportunityName__r ? and finally it seems there's nothing with validation rule i believe.. can u change your question title — Vamsi Krishna Gosu, Commented Jul 25, 2014 at 11:42

Willem Mulder · Accepted Answer · 2014-07-25 12:47:10Z

1

Seems like you now have it inverse to how you want it.

Fix it like

IF(NOT(ISBLANK(field__r.field__c)), OpportunityName__r.Account.Name, field__r.Account__r.Name)

or

IF(ISBLANK(field__r.field__c), field__r.Account__r.Name, OpportunityName__r.Account.Name)

answered Jul 25, 2014 at 12:47

Willem Mulder

3,49128 silver badges51 bronze badges

IF(ISBLANK(exp),a,b) seemed to be ok. I messed up with the fields. I appreciate your help. Thanks
– MnZ
Commented Jul 28, 2014 at 11:30

Add a comment |

1 Answer 1