How to collect contacts to the "assigned to" column

HI,

I'm trying to build flow in my project set-up to handle the "assigned to" column and as I have around 200 tasks in my standard project I want to make it as easy for me as possible :-)

I have a sheet for estimating time spent on tasks where I assign time for each task in a column for each profession. Some tasks are shared by different professions so LD does 5 hours and AD 2 hours on the same task, some shared by as many as 4 professions.

In the Estimate sheet I identify the professionals working in my project and add their e-mail in a profession specific column corresponding to the row in which there are hour assigned.

So far all is well but when I try to import the addresses from the Estimate sheet to the assigned column in my project sheet I get the names instead of the e-mail addresses. ( John Smith instead of john.smith@smartsheet.com) All columns are contact columns and the "allow multiple contact" button is on. I use the following formula.

=JOIN(DISTINCT(INDEX({Projekt est Proj person}; MATCH([Row ID]@row; {Projektestimering Row ID}; 0)); INDEX({Projekt est LD person}; MATCH([Row ID]@row; {Projektestimering Row ID}; 0)); INDEX({Projekt est PL person}; MATCH([Row ID]@row; {Projektestimering Row ID}; 0)); INDEX({Projekt est AD person}; MATCH([Row ID]@row; {Projektestimering Row ID}; 0)); INDEX({Projekt est SD person}; MATCH([Row ID]@row; {Projektestimering Row ID}; 0))); "; ")

Does anyone know why it doesn't work? I'd be super grateful for all help!

/Erik

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!