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