Assigning people from a contact list based on other cells
Good morning
Basically, I have a sheet where each line is a project. Each project has multiple steps, and each of those steps is assigned to a different person based on a contact list. So essentially, each line will have different contacts. We have a cell at the start of each line that allows multiple contacts, where we put all the assigned people from that line so you don't have to go through it manually to see who is all assigned to it. We've been manually populating that cell.
Is there a way to automate this last cell? I was trying to mess with a workflow to "Assign people" in that cell, but I'm not sure how to have it assign to people that appear in that line, if I'm able to.
Answers
-
Hi,
Without screenshots, I can offer a possible suggestion. First, does your team have steps that are always assigned to them, or is it random? If they are always assigned the same step, you can do that through a Nested If formula, or you can have a Contact Sheet that you can index/match.
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
Hi @bakerd163, you could use a JOIN function in the field or even just + them together in that cell, something like =[Contact 1]@row + CHAR(10) + [Contact 2]@row + CHAR(10) + [Contact 3]@row
The CHAR(10) is a new line so this will allow them to appear as individual contacts in that field. Hope this helps!
-
It's pretty random, and our contact list is extensive.
This worked to return the names very well, I may just go with this. Do you know if there's a way for the returned names to be formatted as their contact list? We were trying to get the final cell to save essentially as a contact list for each project to simplify contacting involved individuals.
-
I think it is possible by changing the original contact columns to be email address only (no Name), then adding those contacts to the formula column. It's definitely a limitation. Sorry wish I could help more.
