Question on Cross Sheet Formula
Hi,
I am trying to write a cross sheet formula that pulls a list of tests for a manufactured item for a specific project and keep running either into an Argument error or UNPARSABLE error:
I have tried the following iterations of the formula:
=INDEX(COLLECT({Individual testing assignments Range 1},{Individual testing assignments Range 2} HAS({Batch Summary sheet Range 2}, {Individual testing assignments Range 2})))
The intent of the formula is to pull all of the testing requirements: {Individual testing assignments Range 1} for the manufactured items called out in {Batch Summary sheet Range 2}.
Where {Individual testing assignments Range 2} and {Batch Summary sheet Range 2} are matching columns.
Any help would be greatly appreciated!
Answers
-
Hi @Steve Gaertner , is it possible that you are just missing the comma that should be between "…Range 2}, HAS…" in your formula above? I didn't test, but I know that formula won't work as pasted above :)
Let me know!
Will
-
Thanks for check, that fix returned an incorrect argument set error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!