Getting end users to work with multiple cross-doc tables

[Tim_Sherrod]

Well I think I can use this to modify the row, so I wonder if I just have my main formula set up wrong and it is failing.

Pro hack: Trigger cross-doc sync with an action (hidden formula)

Let’s say Doc A is a data source and Doc B is where you have the sync table from Doc A. I see the process like this: Doc B inserts a row into Doc A through a Cross-doc action Doc A has an automation listening on new/updated rows in that table you just inserted a row to. When automation triggers, Doc A updates that trigger cell in Doc B through a Cross-doc ModifyRow action. Doc B has an automation listening on that cell change, as per the trick. This triggers the startsync/synctabletable scenar…