Editor Moving Rows on a Sheet

I ran into a concern today with Smart Sheet. In an attempt to copy rows from someone else's sheet (on which I am an editor) to my task list so I could keep track of items assigned to me, I accidentally selected move. Unfortunately, once I did, it moved the rows and would not let me move them back. I was able to copy and paste them back in (and retyped any comments). It appears that while any editor can move rows from a sheet to a sheet they own, only the owner can move them back to their own sheet.

Has anyone else run into this issue or have a solution?

Find more posts tagged with

Sharing and Collaboration

Comments

Alejandra

Hi sparlett,

When moving or copying rows to another sheet, you'll want to make sure the destination sheet includes identical column names and types (I'd recommend "Saving as New" without retaining sheet data). If it doesn't, data from the row(s) you moved will be inserted into new columns to the right of existing columns.

If you're not shared to the source sheet with Admin permissions, you wont be able to move the row(s) back to the source sheet if both sheets don't have identical column names and types —since Editors cannot create new columns.

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/504748-moving-rows-columns-cells#moverownewsheet

For more information on Save as New see: https://help.smartsheet.com/articles/803778-copying-a-sheet

Sign in to join the conversation!

Quick Links

Trending discussions

I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…