using index match to automatically pull newly created cell data from form
I have been successful at pulling previously populated cell data from sheet A which is auto-populated by Form A to populate specific cells in sheet B; however, I have not been able to find a way to automatically pull newly populated data coming in from Form A or a recurring/cyclical basis (e.g. anytime a new form entry is filled, the specific cells I need to be copied, are copied and pasted to the specific cell locations needed.
I am currently using this formula within Sheet B: =INDEX({Sheet A - Support Request Range 3}, MATCH({Sheetname A- Support Request Range 2}, {Sheetname A - Support Request Range 5}, 0))
Works for populated data but is not looking for new data coming in from Form A. Thoughts?
Answers
-
Hi there,
Are you selecting the entire column (including the column header) when selecting your reference sheet range? That will allow it to look at the entire sheet and not just the currently populated data.
Let me know if that helps or if I am missing something on how you're using your reference data.
-
yes I am selecting the entire column, including header when selecting the reference; however, if I populate the formula down the destination spreadsheet; it was not picking up test data that I populated on the source spreadsheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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