+1 Having the same error by sorting a filter view when one column is simply a cell reference to another sheet in the same document.
Formula: ='designs'!A31 Error: The formula in cell 'designs'!A31 is referencing a relative range outside the filter. This is true when the referenced cell is simply a value (but just in another sheet). Sorting works fine in the regular Filter but breaks with #REF in a filter view. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
