JOIN COLLECT NOT WORKING COULD ANYONE HELP

Im trying to pull out a column after checking two criteria with join collect but not seeing any value, see below:

=JOIN(COLLECT({TEST2 Range 3}, {TEST2 Range 2}, [SALES ORDER]@row, {TEST2 Range 1}, [LINE-NO]@row))


FROM

Could anyone in SC look into this?

Thanks

Answers

  • Brett Smith
    Brett Smith ✭✭✭

    Hi Seagent,

    In your COLLECT Function you haven't defined the criteria for the ranges you are assessing agains. I assume you want to see where:

    {TEST2 Range 2}, =[SALES ORDER]@row, and

    {TEST2 Range 1}, =[LINE-NO]@row)

    So add in the equals signs for the criterion.

    Then don't forget your delimiter in the Join function - is it a SPACE - " " , a Return - CHAR(10) etc

    So, formula becomes...

    =JOIN(COLLECT({TEST2 Range 3}, {TEST2 Range 2}, =[SALES ORDER]@row, {TEST2 Range 1}, =[LINE-NO]@row), CHAR(10))

  • Hi Brett,

    Still its not showing up any value. Know that the logic is right but there is some little thing that could be causing an issue. Anyways thanks for offering a hand. Cheers


    😊

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Double check that you have selected the correct ranges first.


    How exactly are each of the different ranges filled in?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!