-
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
-
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?
-
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…