Can we get the parent field value by comparision in the formula field? a object has two parents. we need to get that two parent value in formula field but the condition is. need to check the first parent, whether the value is null or not, if null get the second parent field value.
object names:
ob1
lookup fields: ob2 (field name is descrip) ob3 (field name is descrip)
i have tried liek below:
if( ob1_r.desc != null, value, obj_2.descrip);
above is right?