I have a lot of saved filter views for my transactions tab, but I notice that in those views, it doesn’t always get the date sorted correctly. There might be 6/4/21 at the top and then a random 6/7/21 a few rows.
So I tried to save a new filter view where I simply sorted all transactions by date, but for some reason the “Group” Column gets messed up when I do this filter and doesn’t display group and shows an error message. The group column also messes up when I sort the amount column.
This is the error that shows in the Group Column:
Error Did you mean I$1:I? In a sorted filter view, range references must refer to the same row, or be absolute ($ before row numbers).
Also FWIW, I have changed the order of the columns in the transactions tab… not sure if thats a problem (hope not!). Here is a screen shot for formula and column headers.