Copy an indented row in multiple places

Corentin Dal Farra

Hello,

Do you know if we can copy a indented row (or just a row could be good also) in multiple places on a sheet ?

For example I have a sheet with 100 projects all structured in the same way,

I would like to add a specific task for each project between two other tasks, without doing it manually for each projet.

Thank you very much

Genevieve P.

Hi @Corentin Dal Farra

There isn't a way for the sheet to know automatically where this task/child row should appear, however if this row is the exact same for all 100 projects it won't take too long to manually paste the exact same row into the right place.

To copy the row, make sure you've selected the entire row by clicking on the row number, then either using the right-click dropdown menu or keyboard shortcuts to copy the entire row:

Then find & select the row that you want your new task to paste above:

The entire row will then paste as a child.

Then since the row is already copied to your clipboard, you'll just need to find the area to paste in and quickly use the keyboard shortcuts to duplicate this data. Will that work for you?

Let me know if I've misunderstood what you're looking to do and I'm happy to help further.

Cheers!

Genevieve

Genevieve P.

Hi @Corentin Dal Farra

There may be another way to do this, depending on your specific set-up. For example, you could potentially paste the row 5 times, then copy all 5 at once to then paste 5x faster... then you could use the SORT function in your sheet to organize where these rows should appear. However in this case you would need to manually indent them since the Sort wouldn't be able to tell if it's supposed to be a Child or not.

Another option would be to have each project split onto its own sheet, and then you could have a workflow set up that whenever a row is added on one sheet, it copies it over to the other projects. In this instance you would still need to adjust where the row appears in the project, as the workflow won't be able to tell if it should go anywhere other than the bottom of the sheet.

Finally, you could look into using the Smartsheet API to copy rows. However I think, based on your initial description, manually copying/pasting the task where it should be is actually the best way to proceed to ensure that all of your information is actually in the right order.

I hope you have a nice day as well!

Cheers,

Genevieve

Genevieve P.

Hi @Corentin Dal Farra

There isn't a way for the sheet to know automatically where this task/child row should appear, however if this row is the exact same for all 100 projects it won't take too long to manually paste the exact same row into the right place.

To copy the row, make sure you've selected the entire row by clicking on the row number, then either using the right-click dropdown menu or keyboard shortcuts to copy the entire row:

Then find & select the row that you want your new task to paste above:

The entire row will then paste as a child.

Then since the row is already copied to your clipboard, you'll just need to find the area to paste in and quickly use the keyboard shortcuts to duplicate this data. Will that work for you?

Let me know if I've misunderstood what you're looking to do and I'm happy to help further.

Cheers!

Genevieve

Corentin Dal Farra

Hello @Genevieve P

Thank you for your answer,

Yes it works fine with your method. Effectively it won't take too long, but If there were a feature to do mass copy it could be very useful for sheets with bigger rows number.

Have a nice day !

Corentin

Genevieve P.

Hi @Corentin Dal Farra

There may be another way to do this, depending on your specific set-up. For example, you could potentially paste the row 5 times, then copy all 5 at once to then paste 5x faster... then you could use the SORT function in your sheet to organize where these rows should appear. However in this case you would need to manually indent them since the Sort wouldn't be able to tell if it's supposed to be a Child or not.

Another option would be to have each project split onto its own sheet, and then you could have a workflow set up that whenever a row is added on one sheet, it copies it over to the other projects. In this instance you would still need to adjust where the row appears in the project, as the workflow won't be able to tell if it should go anywhere other than the bottom of the sheet.

Finally, you could look into using the Smartsheet API to copy rows. However I think, based on your initial description, manually copying/pasting the task where it should be is actually the best way to proceed to ensure that all of your information is actually in the right order.

I hope you have a nice day as well!

Cheers,

Genevieve

Corentin Dal Farra

Hello @Genevieve P

Thank you for the additionnal solutions that you provided !

Corentin