Submissions are via a form to our smartsheet - manually adding subtasks can I automate?
We have our team submitting requests for work via a form with a few required columns and some nice to have information to generate into the Smartsheet.
We have been manually copy and pasting the subtask rows each time a form is submitted. then we indent those to get the parent child relationship. They are always the same exact rows we are copying and pasting in the same exact order.
Is there a way to automate this. it is very cumbersome. This would be a major win for our team if we could get it to automate when a new form is submitted to create the subtask rows beneath it and indent.
Let me know what solution there is other than manually modifying the sheet.