I want to update a field on the the account object based on a field being updated on the contact object, in this case a date / time field.
So far, I have setup a lookup relaionship field on the account object that is connected to the contact object. Then I created a formula field on the account object that calls the correlating field on the contact object via the lookup relationship. (Contact_to_Acc_Link__r.Form_Filled_Out_Date__c).
I went to test it by setting the date in that field on the contact, then checked the related account, but the field wasn't set.
What would cause it to fail? Or is there a better way of accomplishing this task?