I am trying to write a formula for below scenario
Opprtunity : Field 1
Product (Custom Object) : Field X
Field 1 updates when field X is Certain value. I have created lookup relationship between opportunity and product so that i can access the field x
Formula for criteria of workflow I am writing is opportunity__r.field x == "Test"
it seems not working and I don't understand why? Can anyone please help?