ISSUE (5/13/24): If you delete a row in the register, it can cause the next row to not be referenced in the dashboard charts because of a #REF error in a hidden column. In the screenshot below, there are 3 hidden columns which includes column ‘O’ where the following formula can be found in cell O5: =TRIM(MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1),1)+1,255))
Here’s a corrected version that doesn’t mess up when a row is deleted: =TRIM(MID(CELL(“filename”,A$1),FIND(“]”,CELL(“filename”,A$1),1)+1,255))
If you want to fix this in your existing spreadsheet, start by unhiding columns M-O and then click your cursor into the first occurrence (cell O5), and update the formula so that the reference to “A1” becomes “A$1” in both areas of the formula. Next, copy (fill) that updated formula all the way down, and then repeat this update on all of the other register worksheets. You can also download the spreadsheet again from Order History or from your emailed receipt as this has been corrected in the most current version posted to the site.
ISSUE (4/21/24): On the Reconcile sheet, the formulas that are located in the following cells are incorrect. Cells: H7, H8, I7, I8, J7 and J8. They reference “Register3” but row 7 should reference Register4 and the formulas in row7 should reference Register5. You can correct those references in the formula or you can download the spreadsheet again from Order History or from your emailed receipt as this has been corrected in the most current version posted to the site. See the following screenshot for additional reference.
