HELP! Move Row Automation

I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no "undo" button. Have I lost all my data?

I had something similar happen on another sheet where the status is changed, but instead of just moving the row, it is moving everything to the new sheet. But, at least my data is still available, just on the other sheet

Find more posts tagged with

Sheets

Solution Center

Accepted answers

All comments

PM_Reeves

Hi @tsiears

I thought that I had the same issue when I first started moving rows between sheets.

Just check that your destination sheet doesn't have a whole bunch of empty lines and the moved rows aren't way down the sheet.

I just assumed they'd go to the next available row, but I'd only deleted the content after testing rather than deleting the actual rows.

Good luck.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.