Recently, on a working Coda doc, I decided to make a change.
- Duplicated a Section containing a Table that I was referencing from several other formulas/tables.
- Made some experimental structure changes to the new table.
- When I was happy with the new table, I changed formulas to reference the new table instead of the old (this worked fine).
- Kept the original table/section around for a few weeks in case I needed to look at the original format of the data.
- Deleted the original table/section once I decided the new one worked properly and was a better fit for my doc.
A couple weeks went by before I was alerted that a lot of math in my doc was resulting in incorrect values. After some digging I realized that I forgot to update a couple (hidden field) formulas that were still referencing the original table I deleted. Unfortunately that meant that any field with an error was giving a “0” to my math and screwing everything up!!! It was relatively straightforward to modify the remaining formulas to reference the new table and fix the problem, but I’m worried I may have shaken confidence in Coda with my “team” (I’m getting questions about what this has done to the values).
What I’d like to know: is there a way to list broken formulas in a doc? What strategies are there to deal with this?