Novice Smartsheet User! Need help with Matching/Indexing
I need help with a formula! I'll try to explain this as clearly as I can.
I need a formula that can tell me the value I circled looking within the range of columns "01. Kick-Off Meeting" to "13. New Contract Start", based on the corresponding "Task Name" column, in this example, "Kick-Off Meeting" if the "Task Status" column is "Milestone".
The formula would go under "Task Status" where the cell is selected in the image.
These two images are from the same sheet.
Answers
-
What is the formula you are currently using?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome - none at the moment 😬
-
@Paul Newcome Hoping this provides additional reference...
In Excel, the formula would look like this:
=INDEX($J$5:$L$5,1,MATCH($C5,$J$4:$L$4,0))
For the highlighted column below:
I want to be able to replicate this in Smartsheet but I wasn't sure how to do it since you can't cross reference columns (or can you?)
-
The syntax would be pretty much identical except you can't reference column headers themselves. You would need a row in the sheet that has the column names the same way you have a row in the Excel workbook that has the column names.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!