-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Merged: Dynamic View - @ Mention Contact Name
This discussion has been merged.
-
SUMIFS with a Multi-select Contact Column
Is there a correct way to add contacts into a formula? I am trying to sum the number of attendees per VP (could be a couple VP's in this multi-select contact column) training request. Do I need to type in the full name? Only part? Add in a special function? Details: Completed Projects - Team X # of Attendees = number of…
-
Updating Contacts via M365 / AAD
Hi, Is it possible to link to Microsoft 365, or AAD, and pull through contacts for all users automatically? This way i can type in Jchap and it will come up with my email, or Joe C and it will also populate me for ANY user in the sheet?
-
Importing Contacts
Good Day I have follow the resource document on how to import a csv. contact list with the correct heading row of "First Name", "Last Name" and "Email Address", and have read several posts, but I still cannot seem to use the import functionality. Does anyone have an idea of what else I can try? Thanks
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Multiple Contact list with Request Update
I have found that I can not include a Contact list column which is set to Allow multiple contacts in a automated request an update action. If you include the contact list column, none of the specified fields will show up and the open request web page only has the message, no submit or field list. The only work around I…
-
Edited CONTACTS - flowing to other sheets
If I edit a contact in My Contacts (the Name portion, not the email), will that flow to everywhere the contact is used (all sheets)? It appears the answer is no, and it takes manually editing each instance of the contant on all individual sheets. Hoping this is not the case, or there's an easy solution or workaround.…