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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I knew it was a simple issue! Thanks @Paul Newcome !
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives