Question on Cross Sheet Formula



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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!