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?


There's an easy way. For example, for a sum, you can specify it like this:


So basically, specify the first cell you want, then the name of the column. That way, you can skip as many rows as you want.

  • 1
    Keep in mind you need to put this total somewhere other than in the column you are summing or you will get a circular dependency error. Jan 28 '15 at 23:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.