Index/Collect returning #INCORRECT ARGUMENT SET
Hello, Community!
- I'm trying to bring in the value of the Available? column from the Availability sheet into the same named column on the Schedule sheet where: (1) Rescheduled on Schedule sheet matches Team Member on Availability sheet and (2) Start on Schedule sheet matches Date on Availability Sheet.
- My current syntax (returning the #INCORRECT ARGUMENT SET error): =INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)
Any thoughts?
Best Answers
-
I think you may have your criteria's in the wrong order? instead of:
=INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)
Try:
=INDEX(COLLECT({Available}, {Who}, Rescheduled@row, {When}, Start@row ), 1)
Did that work?
Hope that helps,
Thanks Paul
-
Thanks, @Paul McGuinness!
Answers
-
I think you may have your criteria's in the wrong order? instead of:
=INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)
Try:
=INDEX(COLLECT({Available}, {Who}, Rescheduled@row, {When}, Start@row ), 1)
Did that work?
Hope that helps,
Thanks Paul
-
Thanks, @Paul McGuinness!
-
Hi cghallo_Veolia
I hope you are doing well,
Please create a column for a unique key combination of date and name in both sheets and create a formula for the combination in both sheets like this - (=Start@row + Reschedule@row).
And then please try this formula - =INDEX({Available?}, MATCH([Unique key]@row, {Unique Key}, 0))
I hope this is useful to you, please let me know if you need any other help.
Have a Good Day.
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
-
No worries @cghallo_Veolia glad it fixed it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!