A little trouble with Index(Collect
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))
Best Answer
-
You need to remove one of the closing parenthesis from the end as well as the opening parenthesis before the third range.
Answers
-
You need to remove one of the closing parenthesis from the end as well as the opening parenthesis before the third range.
-
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
-
Happy to help. 👍️
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
Check out the Formula Handbook template!