Concatenate two columns from JOIN/COLLECT Condition



I would like to concatenate 2 columns based on my JOIN/Collect condition, I am able to achieve only partially but not fully expected result. Appreciate if someone can help in this query

I am collecting Task name based on following condition:

=JOIN(COLLECT([Task Name], {Status}, <>"Complete", {Release}, "Yes", [End Date], <=TODAY(30)), [End Date]@row + CHAR(10) + CHAR(10))


Task 2

Task 3

Instead of only task name I would like to End Date concatenated with Task Name:

3/20/2022 Task 2

4/30/2022 Task 3

Kindly Help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!