Index/Match Row ID
Options
Michael Culley
✭✭✭✭✭
Can anyone explain why this would not work?
=INDEX(EQ:EQ, MATCH([Row ID]@row, [Row ID]:[Row ID], 0))
It gives me #No MATCH.
I realize that's a silly formula but my original formula was this:
=if(LEFT(EQ@row,1)=4,INDEX(EQ:EQ, MATCH([Row ID]@row1, [Row ID]:[Row ID], 0)),"")
It literally worked and then suddenly switched to #NO MATCH a minute later.
Is this a bug?
Answers

Also if I do the match formula without the index, works perfectly.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!