Join/Collect across sheets


I think I am really close with my formula, but still getting an unparseable error.

=JOIN([Freelancer's name]@row:{Feedback Range}, COLLECT({Feedback Range}, {Audition Status Range}, [Audition Status]@row), "'s ")

I have a source sheet (Feedback) that contains 3 different feedback text, for three different Audition Status scenarios.

When the Audition Status on my current sheet matches the Audition Status in the source sheet, I would like to add the Freelancer's Name (on the current sheet) to the feedback text, with a 's as the delimiter. (The aim here is that an admin can copy/paste this message.)

Images attached to show the two sheets.

Thank you!


Best Answer


  • Hannah H
    Hannah H ✭✭✭✭✭

    Thank you @Genevieve P that worked. I guess I was trying to make it too complicated!

  • Genevieve P.
    Genevieve P. Employee Admin

    No worries at all, I'm glad that worked for you! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!