I have a complex Estimation s Spreadsheet in Google sheets. * indicates steps that I am stuck on.
- I Created Google form to act as data capture for New Quote Requests
- Made a Zap that Creates a new Folder name based on the estimate # in my form response spreadsheet
- *I need to input the entire line of data from the Form Submission into my Estimate Spreadsheet Template (Sheet 1 row 3 ) but it keeps posting all of the information into Cell A3 rather than into each individual cell in row 3
- My Zap then Creates a Copy of my estimate template and re names it based on the Job #
- *I want this New Estimate spreadsheet to save into the new folder I created in step 2
- *I want to have a sub folder that is created in each new folder from step 2
If anyone has any input on steps 3,5,6 it would be greatly appreciated