How to collect contacts to the "assigned to" column

Erik_W

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

Bira

@Erik_W

If you want to have emails like hdrw@e-mail.com, you need to change the column properties to text or number. Alternatively, you can create a dropdown for all emails and allow multiple values per cell.

Erik_W

@Bira

Thank you for your answer.

I want contact info and the columns I try to collect the contact info from have contact info and are formated as contact columns. The "Assigned to" is also a contact column.

I think the problem is some kind of restriction regarding the "Assinged to" column…

/Erik

Paul Newcome

For multiple contacts, you have to use the email addresses (not just named contacts). That way you can bring over a list of contacts and then use one of the methods outlined in the thread below to turn them into usable contacts for things like filters and automations.

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column