Hi Harold, On Thursday, February 12, 2015 at 2:24:43 AM UTC-2, Harold Kyle wrote: > > +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. >
I keep getting this same error. Did you sort it out? Or any alternatives? Thanks so much! Fernando > > > 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.
