Automation trigger to move all cells in grid to anther grid when triggered by data in one cell.
I set up a grid to gather information for a 50 can check. We do these checks randomly throughout the day. So I need the data from the last check to stay in the grid until a new check is done. I set up a trigger to move cells when a cell has a certain data like 1st check, 2nd check, or extra check to move cell with the condition to a different grid. I was hoping this would clear out all the previous checks. But it only moves the cell with 1st check, 2nd check, or extra. The rest stay on the grid. Can someone help?