Is there a way I can lookup an User based on Id/ name I want to achieve the following
1) Object A has User lookup when the User lookup changes I am using a formula on related object to Object A to populate the ID/name of the lookup
2) I do not want to use a trigger. I want to associate the lookup populate on the object B based on Object A lookup changes.
Please point me if there is a simple solution,
I tried to trigger a workflow based on formula change. (bummer can't do this, still tried for nothing)