Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named "ABC Verizon".
I use the match function and it is something like this:
match("keyword", {ABC AT&T (XT1973SK) Range 1}, 0)
Is there a way to refer to a cell in the sheet name? Basically, I want something like {("ABC"+ [primary column]1)Range 1} to refer to a sheet.
Comments
-
Hi Karl,
You would need to create a new cross-sheet reference to accomplish this. Otherwise, you might consider using INDEX with your function to get down to the cell level.
- More on INDEX: https://help.smartsheet.com/function/index
- More on Cross-Sheet formulas: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!