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?


Tags:

Best Answers

Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    Hi @cghallo_Veolia

    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

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭

    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⬆️"

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭

    No worries @cghallo_Veolia glad it fixed it.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!