Using Index to create sheet values

I am using Index to create new sheet values. I am finding that I cannot add rows to the new sheet that do not use the Index function and still have the sheet function properly. If I add rows with no Index, when the source sheet for the Index is changed, the new sheet will have data changed and removed incorrectly.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!