I have a large Google sheets form with about 2000 lines and growing.
I have set up a report to notify me for inventory items that expire within the next 60 days that runs each week.
The report works fine for all the items in the first (aprox) 1000 lines but after it seems that the data is not taken into account anymore.
If I place the line higher up in the sheet then the report works fine so the data in the line and expression seems to be ok.
My expression is AND([Expiry Date]<Today()+60,[Station]=“XXX”)