Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
What is the best way to consolidate data from multiple sheets to a single row
Hi, hope someone can help me.
I am using smartshheet as an internal onboarding process. This process requires me to collect data from 2 webforms entry for same client that autofills 2 different smartsheets, one smartsheet with about 20 colums and other with about 35 columns, OR a single webform to a single master smartsheet with at least 70 columns.
I use the data in sheet auto autofill data to Docu-sign app through apps integration and also smartsheet merge to make welcome pack docs containg info from webform entry
i need to combine this data together into a single format somehow.
I am trying reports and have tried cell linking but the fact that smartsheet uses row ID as logic, each time I enter a webform it completes in the next enpty row or when I run report it also enters on seperate rows..
Does the community have any ideas on how i can proceed to make this work?
thanks in advance