Getting error while indexing entries from other sheet.
Hello there!
A little background:
So I have 2 sheets that get inputs from two forms (Form 1 and Form 2). Both sheets belong to the same student(one gets filled by the college and one by the student). I am using the ID number as the identifier and
On the backend of Form 2 I have used the index match formula to gather all the information from Form 1 using the ID number as an identifier.
The formula is working correctly, when I make an entry on both forms, form 2 pulls all the information from form 1 (indexed) and 2 itself.
The problem arises when I make more than one entry, all the indexed values from the first entry start showing #NOMATCH, and when I make the third entry the first two show #NO MATCH, and so on.
Can anyone let me know what am I doing wrong here?
Attaching SS for reference
Answers
-
What exactly are your formulas, and are you able to provide a screenshot of the source(s)?
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!
Help Article Resources
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
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!