Tutorial: Column Mapping to Make Templates Shareable

I’ve seen that behavior, @richl, when I replace a sheet in the middle of a dependency chain (including when performing a Restore in the Tiller Community Solutions add-on) like replacing Accounts in this chain:
Balance HistoryAccountsBalances

(This is a flaw in the add-on functionality. I’d fix it if a) I had a solution, and b) the problem happened more frequently (but most of our intermediate dependencies are pretty stable sheets).)

I think that happens because our Restore process deletes Accounts— essentially breaking the references back from Balances— then inserts a new sheet with the same name… and without the formula jostling Sheets doesn’t quite realize the INDIRECT() reference back from Balances is functional again.

I haven’t seen these formulas fail when inserted as a new sheet. I find them pretty reliable.

1 Like