How can I allow my "viewers" to sort Google Sheets?
<p>When I share a Google Sheet with view-only permissions, viewers can sort the sheet by the values in a given column, but doing so produces errors, indicating that </p>

<blockquote>
  <p>"the formula in cell XXX is referencing a range in the active filter that is not in the same row".</p>
</blockquote>

<p>Is there no way for "viewers" to sort Google Sheets?</p>