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
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!