Sunday, January 29, 2023

If Filter In Google Sheets Isn't Working

 Sometimes the filter doesn't work in Google sheets in Android. On clicking the inverted triangle icon filter, nothing is displayed. I don't know why it happens. 


Here is a simple workaround. 


Take a copy of file before starting

  • Create new sheet in the original file
  • Create working filter 
  • Copy few rows and confirm working filter
  • Change references to new sheet and confirm vlookup in referencing sheet is working
  • Copy rest of rows to new sheet and modify references in referencing sheet to new sheet
  • Delete old sheet where filter is not working
  • Rename new sheet
  • Confirm everything ok

By at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • What Kind Of Man Can We Not Tolerate
    A friend and I collated the following traits in men that women cannot tolerate in men. We specifically did not include things like his loo...
  • Can't You Take A Few More Steps
    Recently a friend of mine asked his sister whether she couldn't take a few steps to help him out. It happens that she had done plenty fo...
  • Define Freewil
    Free will is the ability to take a decision without being coerced by other parties. For example if I am doing recruitment, I do not have f...
  • What Fazes One
    I made an interesting discovery yesterday . What fazes some people is not a plethora of problems in their but the fact that their effo...
  • Going On A Trip - Tips
    Some of my friends ask me to help them plan their travel for vacation.  They have toyed with the idea of traveling alone and want to k...

Featured Post

Can't You Take A Few More Steps

Recently a friend of mine asked his sister whether she couldn't take a few steps to help him out. It happens that she had done plenty fo...