Contact List Column add to/don't overwrite
I am attempting to mass-edit my contact column for the purpose of Dynamic Views in a way that will add certain contacts based on the contents in other columns.
Example:
Column A is my contact column
Column B is "State"
Column C is "Department"
Column D is "Advisor"
If Column B=
- Illinois, then I want column A to include "Person 1"
- New York, then I want column A to include "Person 2"
If Column C=
- Math, then I want column A to also include "Person 3"
- English, then I want column A to also include "Person 4"
If Column D=
- Advisor 1, then I want column A to also include "Person 5"
- Advisor 2, then I want column A to also include "Person 6"
So, column A should have 3 people listed, but who those people are will depend on the values in B, C, and D. If I sort by B then add to A based on what is in that column, then that works for getting the right contact for the column B value. However, if I then sort by column C, is there a way to add the right contact to the contact column for these people without overwriting what is already in that column (and thus deleting what I had put in for B). I am looking to do this in mass (not manually adding to each cell) as I'm dealing with 1,500+ rows of data.
Answers
-
Hi @Brendan E
Automating this will depend on how many contacts you have associated with each field.
For example, if you already have Column A filled in manually based on Column B (State), then you could set up an Assign People Workflow that adds a specific contact based on what's input in Column C (Department). You can do this without overriding the current values input, but there is a limited number of condition blocks (20) you can have per workflow.
What I would usually suggest in this instance is having three separate columns, one associated with each criteria to bring back the correct contact. Then you could use a formula to show all three values in one cell as a Text value, but it sounds like you want these to all be Contact type of selections for Dynamic View. There currently isn't a way to join together multiple individual contact values into one multi-select cell using a formula while keeping the Contact functionality. Please add your vote and voice to this Product Idea post, here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives