Using Hierarchy and Forms
I currently have a sheet with a list of projects and under each project, subtasks using the hierarchy indentation.
I have also linked a form to this sheet which requests information for a new project. However, when this form is submitted, the formatting of the hierarchy does not follow so I am left with a newly inserted row, but no hierarchy of subtasks under the project.
Is there a way to format this so the indented tasks under the submitted project automatically appear? I dont want to have to manually create and indent tasks under the project each time the form is submitted.