Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows.
My question here is as follows. In Excel, one could create a macro in the form of a button that would simply take the template rows and generate a new list of rows appending to the bottom of the sheet. Maybe this is a feature not yet thought of by SS. Is this possible today?
Help Article Resources
Check out the Formula Handbook template!