How do I reference a variable column name in a formula?
I'm trying to reference different columns based on a value in a helper column. Depending on the value in the helper column, the value should be pulled from a different column. I know I can do this with nested IF formulas, but is there a way to have the column name populated in a formula based on lookup formulas?
I wanted the below formula to lookup the column name based on the number in the "Index" column, and then pull the date value from the column header specified.
="[" + INDEX([Index Date Row]:[Index Date Row], MATCH(Index@row, [Index Lookup]:[Index Lookup], 1)) + "]@row"
Example, the first row is Index 3, meaning it should pull the date from "Day 0 Start3 Date" (9/3/23) Instead, it shows as text.
Any suggestions?
Best Answer
-
I believe this has already been answered here:
Answers
-
I believe this has already been answered here:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!