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 to auto-populate/insert 10-15 task rows as child items under new project row?
What is the best way to automatically insert a set of (about 10) rows as child tasks under each project row? I am designing a smartsheet based on the Project Sheet template, but in my case we manage a large number (about 150) of projects. Each project is fairly simple: each project contains the same set of 10 tasks. I want to start with importing the list of 150 Projects - one project per Row. Then I need to go to each project row and insert the exact same 10 tasks as child rows under each of the project rows. The result will be a SS with about 1650 rows consisting of 150 projects and 1500 tasks, one row per project and one row per task. I am currently copying the 10 task rows, selecting each project, Ctl+V to paste in the 10 rows, and then indenting the 10 task rows I just pasted. Having to repeat this 150 times seems impractical. There must be a way to write a macro or hotkey or something.