HELP!!!

Nicole_Codi17

I want to add Invoice Number (105) to Invoice Information that was last queried which is shown as 1 in Last. Please help!

Antonie B

@Nicole_Codi17

I think an Index/Match formula is the answer you are looking for.

This will return a value based on a value in another column. In your case, it would look like this:

=Index([INV NO (Query)]:[INV NO (Query)], MATCH(1, LAST:LAST, 0))

You may need to adjust your column names to make it work. Also, the 0 is to return exact matches only. If you set this to 1, it will return a close match if no exact match is found.

You can see more information on the functions here:

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

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

Hope this helps

Antonie B

@Nicole_Codi17

I think an Index/Match formula is the answer you are looking for.

This will return a value based on a value in another column. In your case, it would look like this:

=Index([INV NO (Query)]:[INV NO (Query)], MATCH(1, LAST:LAST, 0))

You may need to adjust your column names to make it work. Also, the 0 is to return exact matches only. If you set this to 1, it will return a close match if no exact match is found.

You can see more information on the functions here:

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

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

Hope this helps

Nicole_Codi17

Brilliant! worked as is!!! THANK YOU!!!

Nicole_Codi17

How would I do this if I am referencing another sheet? I want each new rows added with a 1 to change inv to 1 value in Invoice metric sheet? The formula above worked in the same sheet, but looking to cross reference query sheet. Thank you in advance

Andrée Starå

Hi @Nicole_Codi17

I hope you're well and safe!

Here's the structure for a cross-sheet formula.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0)

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!

Nicole_Codi17

Thank you, Andree!

Andrée Starå

@Nicole_Codi17

Happy to help!

✅Remember! 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!