I'd be glad to, but I'm not sure yet how helpful it would be to do so here, without just sharing the full spreadsheet. Which I would need to clean up and anonymize first. It may be very particular to my needs. I drew inspiration from many other "YNAB spreadsheets" (searching reddit etc.) I can say that learning the SUMIFS formula to sum the relevant transactions for a given envelope was a big key to making it work well. The other details are polish around it. I'm afraid that this might not come across very clear. I found that the more that I desired a certain feature and searched for how to do it in Excel or Google Sheets (or Libre Calc, but there is less specific resources for that) then it gave me the next bit that I needed.
triyambakam|3 years ago