Move Rows to Another Sheet--- rows go to the bottom
When a project is complete we "move the rows to another sheet" so they are off the current project sheets but information is still available. The sheet we are moving the rows to is a duplicate of the original so all columns are identical. When I move the rows they go to the bottom (or close to) of the new sheet, how do I get them to go to the next free row? Finding them at the bottom and moving them is a nuisance. Thanks
Answers
-
Hi Karlie,
Try deleting all the empty rows that are between and then test to move from the other sheet again.
Hope that helps!
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree's suggestion is correct. Here is why...
The row is moving to the next UNUSED row. If a row was used but then the data deleted from the cells, it still registers as a used row. Deleting the empty rows will bring the next unused row up to also be the next visible row.
-
@Andrée Starå I tried deleting all the rows in-between and still nothing worked, the new inputs keep appearing on the bottom of the sheet (~row 1795). Do you have any other options for me?
Thanks so much!
