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

  • Nice Links Of Video And Of Others
    Jokes Godfather's horse Why buy the cow Tom and Jerry Dogs in a bar Standup comedian about IIT, IIM Pizza delivery guy and gynecologist ...
  • Maths Puzzle - 15: Find The Next Number
    My friend gave me this puzzle. Find the number in the series below. 8, 13, 24, 47, 94, 189, 380, ?
  • Fake Footwear On Flipkart
    I came across this article today.  https://m.indiatimes.com/news/india/us-footwear-brand-drags-flipkart-to-court-for-allegedly-selling-fak...
  • High Venus And Evolution
    Most species of snakes lay eggs.. But some give birth to live snakes.. In both cases, the baby snakes are left alone to fend for themselve...
  • 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 d...

Featured Post

Whom Do We Trust

I came across this: APNews being the trusted source of news for half the world.  And there is Truth Social which also is read and trusted by...