I have a custom object that has all the same fields except the value of one depends on the record type. I would imagine I could define a lengthy formula with
IF but is there a cleaner way?
Ideally, I could have a related object and have each entry have their own formula supplied instead of predefined. Then I can use the value of this in the parent formula.
For example, if I have an
Order object and an
Order_Type object, I would like to have
Order_Type have a formula field
Factor but as input, not defined. Then I could use it in
Order_Type__r.Factor__c * Quantity.