I have a scenario that checks dates once a day (11.59PM), if the dates are within a specific range I want to add the rows to a another tab in the google sheet, I also want to delete the same rows from the sheet they came from.
So essentially moving from one sheet to the next, then deleting from where they came from.
This is the error message I get:
*** 400: INVALID_ARGUMENT - Invalid requests[0].deleteDimension: Cannot delete a row that doesn't exist. Tried to delete row index 456 but there are only 454 rows.**
The Upcoming sheet has 456 rows, row one is a header.
Here are the settings:
Module 01
Module 02
Module 03
Blueprints:
5. Upcoming - Add to Main - Delete Row.blueprint.json (35.3 KB)