How to write Workflow rule which check if two fields are blank

Question

I have two Records A__r(parent) and B__r (child),

On the records, there are two Fields: c(TEXT) and d (lookup to A)

I need a Workflow Rule which updates Field C(TEXT) on Object B if Fields: C on child and D on parrent are NOT EMPTY. I tried something like that:

NOT(ISBLANK(field_C)) && NOT(ISBLANK(A__Parent_Item__r.Field_D))

but the WF is not triggerd. Why ?

Steve Dodd · Answer

Depending on the data types of your fields on the parent object, the formula for the rule criteria would look something like this:

AND(
NOT(ISBLANK(Parent_Object__r.Field_C__c)),
NOT(ISBLANK(Parent_Object__r.Field_D__c))
)

* Use the Insert Field button in the formula editor to select your field API Names

Sales And Marketing