One form for multiple sheets

Is it possible to use one Form to fill-in fields in different sheets depending on the option selected. For example, if a user selects Sheet1 then data would be populated in Sheet1, and when user selects Sheet2 data would be populated in Sheet2. All sheets would have the same layout and same required data to be filled-in, I would just like to have data separated in the sheets but still use only one Form.

Find more posts tagged with

Forms

Support

Comments

Joey Razzano

If this were me, I would link the data from sheet 1 to sheet 2 and use the form from sheet 2 to fill in the data input. The data itself would all reside in sheet 2 but you can hide it, essentially, creating 2 sheets of data.

Mike Wilday

You can only use one form for one sheet. There is not the ability to split data from form entry into two sheets.

Rafal

Joey,

are you able to go little in depth with your way. I think I have general idea about your solution but do not know where to start.

Rafal

J. Craig Williams

You could automate the moving of rows to other sheets using a third party tool like Zapier (www.zapier.com) or use X-Sheet references within Smartsheet to access the data from another sheet, though that requires one manual step (and a column with unique values)

Craig

Joey Razzano

Ok, turns out you can't link to blank cells so my original thought isn't functional yet. However, a vlookup would work just fine. All your columns in sheet 2 contain all the info you need (but, for the sake of presentation, you could even hide the info in sheet 2 that will show in sheet 1. That way, your form built on sheet 2 will contain all the fields you want to collect. On sheet 1, you could use a vlookup or hlookup that pulls in the info collected in the form from sheet 2 and you'd effectively have 2 unique sheets to share. Use the row number for your vlookup key field (so both sheet 1 and sheet 2 would have the primary column with 1,2,3,4, etc

so sheet 1 columns would be numbers, info a, info b, info c.

=vlookup(numbers, range from sheet2,2,false) for info a

=vlookup(numbers, range from sheet2,3,false) for info B, etc.

Sheet 2 columns would be numbers, info a, info b, info c. info d, info e, info f

Form would collect info for info a,b,c,d,e,f. in sheet 2, columns 1-4 are hidden.

sheet 1 would display info a,b,c and sheet 2 would display info d,e,f

That's how I'd do it until you could link to blank cells if you don't want to mess with third party apps. Good luck

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…