Can the INDEX formula automatically update to pull the next value?


I'm using an INDEX formula to pull a specific cell value from one sheet to the next, but I want this formula to automatically update so that every time a new cell value is added it will update on the new sheet as well. Is there a way to do this?

Right now this are the cell values I'm pulling from in Sheet 1-

To sheet 2-

Appreciate any help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!