- Thread Starter
- #41
Well, it looks like I discovered a Google Sheets bug/glitch. Good thing I checked!
When I'm logged in as my admin account, all formulas work 100%.
BUT, when I logged into a view-only account (just like you guys do)...
The formula for Bassaholic works at start, but as soon as you create a "New Filter" and sort in any direction, other than the original...the Bassaholic rank fails.
To fix this, I un-hidden the Small, Small/Medium, Large, Extreme columns, and shrunk them.
At least you guys can sort without problems now.
So, the problem is...the code works, but as soon as you hide a few columns...the code breaks when you sort it differently.
Obviously, this shouldn't happen. I'll see if I can submit the feedback to Google to get this fixed.
When I'm logged in as my admin account, all formulas work 100%.
BUT, when I logged into a view-only account (just like you guys do)...
The formula for Bassaholic works at start, but as soon as you create a "New Filter" and sort in any direction, other than the original...the Bassaholic rank fails.
To fix this, I un-hidden the Small, Small/Medium, Large, Extreme columns, and shrunk them.
At least you guys can sort without problems now.
So, the problem is...the code works, but as soon as you hide a few columns...the code breaks when you sort it differently.
Obviously, this shouldn't happen. I'll see if I can submit the feedback to Google to get this fixed.