How can I create a function that separates a string of words separated by commas into rows?

Justin Kwong

=JOIN(COLLECT([column1]:[column1], [column1]:[column1], ISTEXT(@cell), [column2]:[column2], =""), ", "). Right now, I have this function in my sheet summary to concatenate all strings that have text in column1 and has no text in column2.

The output it gives me looks something like "task1, task2, task3, task4, task5, task6, task7, task8, ...". The problem I need help on is using this output to create a row sheet summary with each of the tasks separated into its own row. Something like parse...

If this method doesn't work, is there a way to 1. collect all parent tasks of my project and 2. create a row sheet summary with each of the parent tasks in its own row, without having to make a function for each parent function. I want smartsheet to have the end goal of being fully autonomous even if I were to add new parent functions into the sheet.

Paul Newcome

Have you looked into creating a row report?

Margaret Walker

@Paul Newcome can you provide additional details on a row report? Sorry I also pinged you on another string for another question. My apologies for bombarding you with requests. I hope all is well and have a great day.

Andrée Starå

Hi @Margaret Walker

I hope you're well and safe!

More info.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Margaret Walker No worries. It looks like Andree has provided a link to setting up a row report. I have also responded on the other thread.