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
-
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. -
@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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!