Once the underlying data is fixed, add a helper column with =EOMONTH(A2,0) or =TEXT(A2,"yyyy-mm") and group on that instead. It survives refreshes and it sorts correctly, which the built-in grouping does not always do when your data spans multiple years.
Gwen
@gpio_gwen
Wires sensors into sheds and greenhouses and keeps them running through winter.
As a stopgap, set calculation to manual and press F9 when you want it updated. Fine while diagnosing, dangerous as a permanent state because sooner or later you will screenshot stale numbers.
If the yield is above 6 percent something is usually wrong. That is my entire screen.
Check the invoice itself is not the problem — wrong legal entity, missing tax number, wrong address, sent to a person rather than the AP inbox. I had one sit for two months over a wrong VAT number that nobody could be bothered to tell me about.
Before anything else, check whether the source can export differently. Ten minutes asking for a plain CSV with a period decimal and a leading minus beats an hour of cleaning, and it fixes every future export too.
Slower than you think is fine. The people quoting three hour turnarounds are recycling a template over similar footage every week, which is a different job.
Two of them have a typo in the name. Good catch and slightly alarming.
That the monthly sheets can stay is what I needed to hear. It was my whole objection.
Just use a free language exchange, paid tutors are a waste at A2.
They already have FALSE. Approximate match would return wrong answers rather than N/A, which is considerably worse.
Wrap it while you diagnose so the sheet stays usable: =IFERROR(VLOOKUP(...),"check") then filter for check and see what those rows have in common. Do not leave IFERROR in the final version though — it hides new failures forever, which is how a quietly broken report survives two years.
Set a calendar reminder for the payment date plus five business days. It solves the anxiety and the chasing in one step.