A little trouble with Index(Collect

AJCruz

Good day Smartsheet gurus out there

I'm trying to collect data from one sheet (Source sheet) and bring it to another sheet where it will be compiled with similar data from other sheets (Destination sheet). Source sheet contains 3 columns where activity is broken down into phases. What I need to do is bring the % complete data only for a specific task (Bore) of all the different jobs to their corresponding line in the destination sheet. I've come this far with my formula (which does not parse) based on my research and review of the many discussions but I'm now at my wits end. I'm beginning to wonder if index(collect is the best match for what I'm trying to accomplish. Any support and guidance is appreciated. Below current formula and snapshot of source sheet.

=INDEX(COLLECT({Source sheet- % Cmp}, {Source sheet - WO}, [Job number]@row, ({Source sheet Task}, "Bore"), 1))

Paul Newcome

You need to remove one of the closing parenthesis from the end as well as the opening parenthesis before the third range.

Paul Newcome

You need to remove one of the closing parenthesis from the end as well as the opening parenthesis before the third range.

AJCruz

What a level of frustration a misplaced parenthesis could cause :D

Thank you Paul for the pair of expert eyes and guidance. Works like a charm

Paul Newcome

Happy to help. 👍️