copy a line to a different sheet.

BryanOramas

Im attempting to copy row to a new smartsheet. the issue im encountering is im trying to work with another team, like Talent Acquisition's sheet which they own and gather data based on a criteria but im unable to see my sheets when attempting to run an automation. but since AQ owns the sheet i cannot link it and grab data that we need to our own sheets.

im attempting to have the column highlighted in red to copy row to my sheet. is there a formula that may work? i've attempted =countifs but seem to not able to connect someone's elses owned sheet to my owned on.

kowal

hi @BryanOramas,

Make sure that the destination sheet is shared with you as an editor and the columns in the destination sheet are called the same and have the same properties as in the source sheet. If you fulfil those 2 requirements you can smoothly copy the rows between them.

Hope this helps.