So read a few people have this problem.
I wanted a monday board that everytime it updated to only show the list of ones with the field “ready”. and when that changed to “closed”. delete it.
That sheet is then viewed by people. But looks a mess with all the gaps from deletions
I wanted to share a work around.
I made another sheet using the importrange feature in sheets to pull all the data into this new sheet.
Set up a filter on all columns and rows. remove blanks from one of the filters.
There you now have a clean list. hope this helps someone in the future
