Home > Enterprise >  How to refresh a filter onEdit() in Google sheets when editing a different sheet?
How to refresh a filter onEdit() in Google sheets when editing a different sheet?

Time:01-29

I am trying to get a custom data filter to refresh when editing a cell. However the answers I have found such as enter image description here

  1. Select On edit as the event type & save.

Sample Demonstration

  • The test Other sheet

enter image description here

  • The test Main sheet, where I have added the installable trigger & script

enter image description here

  • On my script function, I have added a line to make sure onEdit installable trigger works on line 10 (it will add a simple timestamp on cell C1 to indicate that it works):

enter image description here

  • Say I have edited the cell A1 on my Main sheet:

enter image description here

  • The Other sheet gets refreshed:

enter image description here

  •  Tags:  
  • Related