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?
User | Count |
---|---|
16 | |
12 | |
5 | |
5 | |
5 |