Concatenate two columns from JOIN/COLLECT Condition

Options

Hi

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))

Result:

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!

~Chitta

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!