I have Sheet1, which is automatically being updated via form entries.
I'm making Sheet2, which is a self-sorting version of Sheet1 (it intended to be a copy of Sheet1 but sorted by a column). Ideally I would just auto-sort everything on Sheet1 and not even make Sheet2, but it appears I can't.
If I attempt to select all of Sheet1 as a range, Google Docs will return Sheet1!1:102
. So if I get more than 102 entries on Sheet1, Sheet2 apparently will not include them.
If instead I select the columns on Sheet1, I getSheet1!C:J
. That's better. But I want to exclude the very top row. Otherwise it will sort the column title as if it were just another value.
Is there an elegant way to specify this as a range?
Or do I have to manually pluck out the top row with the filter function or something?