Cell References

@daniel ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to reference a sheet using a cell value, but it doesn't seem to be working. Is it possible?

Cell Value: "Test Sheet"

I want to reference different rows based on the first cell value, basically retrieving different cells from that one "Test Sheet" -- the reason why I want to do that is so I can just copy/paste all of the other references (that are referencing Cell1 for example). See screenshot. I just want a dynamic way of referencing all of the cells, because as we scale - it needs to have some level of automatic. I can't click on references for all of these cells in each of their sheets - that would be too much work.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!