VLookUp or Join/Collect with multiple cell entiers not working
Hi,
I am struggling with a tricky formular - need help.
What do I want?
- I type in cell (Lot joined / 10) any Lot Number e.g. "LHA1" (--> see "black circle 1")
- In cell (Lot joined / 11) only those TW numbers should be returned/displayed that are in the same line as the Lot Number "LHA1" in the yellow table above.
Thx.
Paul
Answers
-
In [Lot Joined]11 try using the formula below:
=JOIN(COLLECT([TW Number]2:[TW Number]6, [Lot joined]2:[Lot joined]6, CONTAINS([Lot joined]10)), '; ")
-
Hi Jason,
I already tried this --> #incorrect argument set.
Regard,
Paul
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!