Contact Field Listing Multiple Contacts to Feed Individual Rows in a Report
Is it possible to parse out a contact field with multiple contacts into a report or new sheet listing each contact on its own row? If that is not possible, can you do the reverse? I hope this makes sense.
Best Answer
-
Hi @StephanieWW
No, there currently isn't a way to parse out a multi-select cell into individual rows/cells automatically.
Contacts are also a specific type of value, so you can't use a formula to take separate contact values and have it appear into a multi-select cell as multiple contacts - the formula will combine the "display name" into the cell, which translates the contacts into Text.
Would you be able to describe your process a little more? If you're looking to Report on Contacts, I would suggest keeping the column to be Single-Select so that you can use the Grouping feature in Reports.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @StephanieWW
No, there currently isn't a way to parse out a multi-select cell into individual rows/cells automatically.
Contacts are also a specific type of value, so you can't use a formula to take separate contact values and have it appear into a multi-select cell as multiple contacts - the formula will combine the "display name" into the cell, which translates the contacts into Text.
Would you be able to describe your process a little more? If you're looking to Report on Contacts, I would suggest keeping the column to be Single-Select so that you can use the Grouping feature in Reports.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks, Genevieve for the fantastic explanation. It makes sense. I am working on building out my project charter process and would love for the identified stakeholders to feed into a stakeholder communication plan. I think I have figured out a workaround by linking the stakeholder communication plan into the Charter intake sheet. Then I display a stakeholder list from the communication plan in the charter dashboard. My main goal with any of this is to reduce duplicate data entry.
-
Sounds like you've managed to link it all quite well! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi, I see that there has been a request to allow contact columns with " Allow Multiple contacts per cell" to appear in a report for quite a few years now. However this has not been remedied as yet.
We are using the report feature for contacts to have a report per dept showing each members assignmentsin all project plans. However as all of our plans have multiple contact columns there is nothing showing in the report.
If I change the plan to have a single contact column then the report picks this up.
Can you help please as this is an urgent request .
Regards
Paul Johnson
-
Contact Columns that have single select or multi-select are both able to be pulled into a Report. However a multi-select column is seen as a different type of column than it's single select counterpart.
This means that you may need to select two columns in your Report column picker to ensure both columns are showing across all your sheets: any of the sheets that have a single select, and all of the columns that have multi-select. Even if the names are the same, the properties are different so they cannot be "combined" in a Report. Does that make sense?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
I have a similar need. I have a project plan template with multi-select contacts in the "Assigned To" column, because a task may be assigned to multiple resources. The template contains generic contacts. I have another sheet that is used to request resources for the project from the resource manager. When the resource is assigned and added to the resource sheet, I want to use VLOOKUP to update the project plan with the named resource. This works great when there is only on generic contact in the Assigned To column. But does not work when there are multiple generic contacts. We are currently having to use find/replace to update the generic contacts.
-
Yes, a VLOOKUP can only find matches if the cell contains an exact match, it can't parse out individual values and search for them one at a time. You would need a reference sheet that has all possible combinations to match against in this instance.
Depending on how many Contacts you have, another option would be to use the Assign People workflow to add the contact based on the content that was selected, see: Assign People in an Automated Workflow
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!