Formula on INDEX

I am fairly new to SS. I see a formula in a cell that reads another sheet and match on a Proposal ID to get another cell back.

=INDEX({Nintex Success}, MATCH([Proposal ID Number]@row, {Nintex Req ID}, 0))

I know Nintex is another folder. But I can't figure out how the formula reference this Success field. The column heading for the Success field is something like Metric Success. I basically need to write another formula to match on the same criteria but grab a column that has a column name such as 'Target Start Date' into this sheet.

Can someone point me in the right direction please. Thanks.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!