Moving rows to another sheet - Admin access

I have a very simple task list sheet. No timelines, dependencies, Gantt, %complete - just a list of tasks with status, priority and similar.

When I set the Status column to "Complete", I want to (manually) move that row to an archive table with the same column set.

A popup box says I need Admin access to move rows. I have Admin access to both sheets. They are in the same Workspace.

What am I missing? TIA.

Find more posts tagged with

Sheets

Accepted answers

IainTheAussie

Sorry, delete that. There was a hidden column, so the column sets were not identical. BUT… Note to developers: it would be nice if the error message related to the actual error. 😊

All comments

IainTheAussie

Sorry, delete that. There was a hidden column, so the column sets were not identical. BUT… Note to developers: it would be nice if the error message related to the actual error. 😊

AngB789

If you are not an admin of the sheets you would need access. However you could also ask the admin of the sheet to create an automation to automatically move the necessary rows when they meet your criteria. I use this to archive project intakes automatically.

IainTheAussie

Thank you, Angela, for a quick response. I am not only the admin of both sheets, but their only user! Anyhow, it turned out to be a misleading error message - see my comment on my post.

Best,

Iain

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.