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

  • Common Mistakes in Perceptions
    I have spoken with many women on the subject of extramarital affairs (EMA for short) and whether it's the men or the women who have mo...
  • Krishna And Kalyavan
    Today I was watching Mahabharata  on TV. Today's episode was about Krishna guiding Kalyavan towards his (Kalyavan's) death. For du...
  • Old Indian Movies, Songs and Actors
    I have been reading about old (primarily 1950s and 1960s) Hindi, Tamil movies and written about it earlier ( http://vbala99.blogspot.com/2...
  • I Should Explain It To You Once (Once = Sometime)
    This phrase and "You should come to my house for tea once" and "We should catch up sometime" were told to me by friend...
  • How Does a Toddler Recognize His Mom
    Recently I happened to come across a young Muslim couple in Kashmir, with a 7-8 month old baby. The woman, wearing an abaya, was holding h...

Featured Post

Trump's Election Interference

I can think anything that may not be true. And I can say untruths because I have a right to freedom of speech. Based on that thought and wor...