How to update a column based on changes in another table

I'm trying to update a Date column on Table 1 based on new rows or changes to existing rows in table2.  I currently have a formula in the Table 1 column, but this requires the row to be saved in order for the update to happen:  SUM(SELECT(Table 2[Buyers Contacted],[Date]=Date([_THISROW].[Date]))).  I would like for the update to take place without requiring the user to save the Table 1 record.  I suspect that this will require some type of automation, but I am new to using the automation approach.  Can anyone point me in the right direction or provide an example?

0 6 294
6 REPLIES 6
Top Labels in this Space