I’m trying to set up a Zap where I add a new row to Smartsheet, then a new document is created from a Google sheet template and the information is added to particular cells. If I were sending an entire row over it would be easy, but my issue is that I want to keep Smartsheet set up as a row/column system, and essentially fill in a form I have created using Google sheet with that information. At the end of each project, that form gets printed and signed by our company and the client. So the google sheet (form) really needs to maintain a professional face. I can’t just print a long row of information. So for every row, i would have a corresponding google sheet that is easier to read than a single row of information.
I want to use Smartsheet because i can keep all of my projects organizes without flipping through the printed forms. Also Smartsheet allows me to set up date reminders so that I dont miss deadlines (which continues to happen when i just fill in the paper copy of the form.
Best answer by Troy TessaloneView original