-
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?
-
How do I change the columns I can "view by" in card view?
I am trying to sort in card view based on the employee(s) assigned to a task. I have a contact list column with this information in GridView. The "view by" feature shows a ton of columns that aren't relevant to how i want to sort but I can't figure out how to switch them out for more columns that are more relevant to my…
-
In CARD view, my contact card OWNER column is not listed as a "VIEW BY" option
I have a sheet that has assigned owners. The owner column is a Contact list type. Contacts are added individually via the column property window. However, I in CARD view, I OWNER isn't an option under VIEW BY. When I edit the lane to add OWNER, it says "Column name is already in use in this 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
-
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…
-
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.…
