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. KickOff Meeting" to "13. New Contract Start", based on the corresponding "Task Name" column, in this example, "KickOff 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?

@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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!