Is it possible to create reference to another sheet by its name?


I'm making a report/dashboard to display data from many other sheets. It's just simply internal links to the cells in other sheets. But due to the number of sheets is huge so I'm looking for a more smart way. Want to know if I have the name of these sheets, like "sheet 1", "sheet 2" ... "sheet X", any formula can read the data of cells in other sheets just by its name?? Like "sheet name!A1:A1" formula of Excel?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!