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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!