Help with Google Forms sync
I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being told. I was able to get the Google Form to sync with my Smartsheet account, however, in order for the form to work, it has to create a new Smartsheet. Ideally, I would like to have the form feed into a procurement Smartsheet that I have already created, added automation, and formatting. If not, is it possible to feed the data collected from the Google Form's new Smartsheet, into my existing procurement Smartsheet? If neither of those is possible, the only other option I see is to copy and paste what I can from the existing procurement Smartsheet.