Formula on INDEX

David C from VA

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.

Andrée Starå

Hi @David C from VA

I hope you're well and safe!

You'd have to create another cross-sheet range.

More info.

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!