Net Worth Sheet - Is balance history descending date sorting required?

Hi @RedNell That’s a good observation and sorry to hear about the additional time spent troubleshooting, but I believe you’re correct that the Net Worth sheet is working off an assumption that the Balance History is sorted Date descending. It appears that it’s doing a filter of any balances before the given date and then taking the one at the top of the list. So if the data is not sorted it won’t grab the one that you expected it to. I was able to recreate your observation. On the other hand, the Net Worth Snapshot is using a query function and sorting the data first - this is why you saw a difference between the two. I could only speculate why the Net Worth sheet works that way, but I think that all Tiller built solutions that populate Balance History will likely always sort it and/or insert the data in the chronological order. So the problem only arises if manual edits are made to the balance history. In this case you would always need to do a sort afterwards. I have numerous manual balances that I update at least monthly and I remarked in recent post that I found it faster to insert them into the Balance History directly than using the sidebar. So I created a template for this and it ensures that the balances are inserted in chronologically descending order. I might do a show and tell to share it at some point.

In the meantime for what it’s worth I can share a slight edit that (although not tested extensively) I think would resolve that for the Net Worth Sheet in case Balance History isn’t sorted. Note that the Net Worth sheet doesn’t look at the Time of day, so more edits would be needed if going for multiple balances in a day (I’m guessing not a likely use-case). If you want to try this then I’d suggest making a copy of the Net Worth Sheet that will be your edited copy- in the hidden area to the far right, under the section Data for Trends Table you can make the following formula edits (note that I was testing it in row 25 but you could start at the top and fill down).

The other way would be to replace the filtering functions with the really powerful QUERY function like the Net Worth Snapshot uses.