Forms Help - Two Columns with same Primary Column Cell Name
Hi All,
I am using forms to gather data that appears to be working as required until I stumbled on an issue this morning.
Forms go out to different people.
The forms contain different questions depending upon who can answer the questions.
This data is captured in a smartsheet then we use a vlookup to pull into a different sheet.
This works until..
A form is sent to multiple people with the same name within the cell of the primary column. Smartsheet adds a column per forms response, however, vlookup appear to read top down i.e. it does not pull the data into the other sheet if some rows are blank on the last received form data (but the data is there for the form received before this).
Is there a way (not manually) to copy / ensure that all data where the primary column ID cll name e.g. Name1 & Name1 have all rows filled in?
Example below:
Column 2 has data is the 'Useful' row, however, this is ignored when pulled into another sheet via vlookup. Can the two columns be merged or can the information in the 'Useful' row (column 2) be copied automatically?
Thank you.
Answers
-
@ss_happychappy I am not sure I understand what you mean by this - "A form is sent to multiple people with the same name within the cell of the primary column".
-
Hi Ella,
I have two forms but one of the boxes that a user will populate on each form will have the same detail e.g. from the screenshot example1 under Business which is a primary column when looking at the smartsheet itself.
Thank you.
-
@ss_happychappy Thanks. I am not aware of merging columns options in Smartsheet, but since you need the data to be on 1 row for VLOOKUP to work, have you considered using Update Request after the initial form is submitted?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives