Auto Number + INDEX/MATCH Numbers Misaligning

Hey,

I've created a sheet that feeds into another sheet using a helper column and using INDEX/MATCH

=INDEX({SourceMonth}, MATCH([Helper Column]@row, {SourceNumber}, 1))

(Example of pulling the month from the other sheet onto the primary sheet using the Helper Column)

However, sometimes, the helper column is randomly going in a different order (...120, 121, 145, 124, 127, 132... example of the sequence that was messed up), messing up the entire sheet and rows will no longer be pulled properly. The fix I have to do is delete the column and reassign the column as a resource and fix all the formulas again.

Is there a better way of fixing this so I

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!