Tried this one it says UNPARSEABLE??
Best Answer
-
Try something like this.
=INDEX({Unit Price}, MATCH([TGS Part Number]@row,{TGS Part Number}, 0))
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hope you're having a great day!
Do you want the formula to return the description or a part number? The above tells me that you are matching a description in some range, collecting that row number, and then displaying the description in that row.
If you could provide some screenshots that would help us get you to the proper solution!
Best,
Lidiya Shutaya
lidiya@ddbconsultants.ca
-
Hi Lidiya,
I need help to return the Source Sheet Column (Category Code (TGS Part Number) in the column to the left of the Destination sheet (Description) column.
The screenshots are below. First is the destination sheet second is the source sheet
Many Thanks in advance
-
I hope you're well and safe!
Try something like this.
=INDEX({TGS Part Number},MATCH(Description@row,{Description List},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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks, works fine
-
Excellent!
You're more than welcome!
Here's the general structure of an INDEX/MATCH formula.
=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row, {ColumnWithTheValueToMatchAgainsTheCell}, 0))
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Please help with the below I`ve done the same but need to return the Unit price value. Linked to Part Number Value. Says the same error as before. I tried to copy what you said above but still no luck.
Please help
=INDEX({Unit Price}, MATCH(TGS Part Number@row,{TGS Part Number}, 0))
-
Try something like this.
=INDEX({Unit Price}, MATCH([TGS Part Number]@row,{TGS Part Number}, 0))
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes thanks that`s excellent work
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!