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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!