Formula to generate a comma separated list

BarneeL

Hi!

I'm hoping one of you guys might be able to advise on a formula I can write to generate a comma separated list based on the contents of a variable number of rows.

 

As a bit of background:

My plan is to have a form in which people can input their email address so that it populates a smartsheet. I'll then use Zapier to use the smartsheet as a mailing list to send out an update when a certain event happens (in another application - hence the use of Zapier).

 

Now, Zapier requires a comma separated list for it's mailing lists. I don't see a way to get it to reference multiple rows on a whole smartsheet to generate the list, so I need to set it up in a way that I can reference a single cell.

 

Any advice on what functions I can use would be greatly appreciated!

Andrée Starå

Hi Barnee,

You can do this with the JOIN Function. My example is for a row but you can select from a column also.

=JOIN(A29:J29; ",") would result in the below as an example.

andree@getdone.se,andree@getdone.se,Smartsheet,Smartsheet,Smartsheet,Smartsheet,Smartsheet,Smartsheet,Smartsheet,Smartsheet

More info: https://help.smartsheet.com/function/join?dlm=112&frame=0&nav=1

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

BarneeL

I managed to do it using this formula:

=JOIN(CHILDREN([Mailing List]3), ", ")

 

I guess it wasn't that hard after all!

BarneeL

Thank you!

Andrée Starå

Great!

Happy to help!