2

I have a child object depending on Accounts. I am using the custom "type" field in accounts an have a depending picklist called "subtype". No all "types" have assigned "subtypes". I want to pull a formula field in the child object that shows the "subtype" value when existant, or "type" value in case it doesn't.

Any ideas?

Thanks!!

Improve this question

1 Answer 1

Reset to default
1

Try the BlankValue() function. It'll check if the first value is blank, and if so, return the second value.

Example:

BlankValue(Account__r.SubType__c, Account__r.Type__c)
Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .