Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I insert multiple rows of external data without overwriting the rows below?
Oftentimes I'll copy rows from excel, email or my browser intending to insert those rows between used rows in my smartsheet. Although Smartsheet recognizes that I am pasting multiple rows, by default it will overwrite existing rows on the sheet rather than inserting new ones.
This means that if I want to paste in between existing rows, I have to first insert the exact number of new blank rows I need, then paste, which is a pain. Alternatively, for large lists, I have to scroll down to the bottom of the sheet where the blank rows are, paste, then move those rows back up to the desired location. This is also a pain.
Is there a way for me to insert external data into smartsheet without it overwriting existing rows?