Indexing Entries from a form generated worksheet
Good Afternoon Smartsheet Pros,
I have created a form that allows the filer to input new hire information for up to 10 new employees in a batch (The need for multiple entry options on the same form was a requirement from the "Powers that be")
I created helper spreadsheets indexing entries using the formula
=IFERROR(INDEX({New Hire Form Range 1}, 0 + $[Entry Number]@row, 18 + [Employee Last Name]$1), "")
These support sheets are setup as pictured
Automation is then used to add these rows to a master employee speadsheet when rows are added or changed. (Though I haven't got this automation working yet)
The primary issue I'm facing is that I have to define the range that these helper sheets draw data from and when a new form entry is populated into the sheet, it is being excluded from the range that these helper sheets have defined. Does anyone have a solution that would allow me to ensure new form data is populating in these helper sheets?
Thanks in advance!
Best Answer
-
If you click on a column header when creating the range, it will select the entire column and will include new entries as they are added to the sheet.
Answers
-
If you click on a column header when creating the range, it will select the entire column and will include new entries as they are added to the sheet.
-
I knew it was a simple issue! Thanks @Paul Newcome !
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives