-
Counting people with the same email domain in a multiselect assigned to cell
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
Add contacts to a cell
Any ideas or workarounds to add several contacts on a sheet to a cell in another sheet? I need to send an alert to the project team. I've shared the sheet with the project team but also with alot of other people who don't need the alert.
-
Form Issue: Auto-Complete Contact Column
Hi All, I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app. When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and show you a drop down of available contacts. When you use the mobile version and are…
-
What is the effective approach to Group Management and Contacts
i would like to have a contact with name. I need Groups so have to add contacts via Group Management else it won't allow me to add a contact from "My Smartsheet Contacts" Within Groups, I can either paste all emails or add one by one. The former will not allow names to be added, the latter is manual and painstaking if I…
-
Contact Lookup/Reference from Another Sheet
Hello, I am trying to work out a formula that will raise a flag if any contacts in a column (Attendees) are listed on a separate sheet (VIP). The attendees column could have multiple names listed, the VIP column will only have one name per row. I am running into errors with the formulas that I have been trying, and not…
-
Using VLOOKUP for Approval Requests Across Sheets
GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated approvers for changes on contracts. Sheet B tracks providers named on the contracts to…
-
changing email address in contact list (web formular)
Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg
-
Formula to return multiple contacts based on multi drop down options
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminders). In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for…
-
Assigning tasks to group contacts
I have created several contact groups in smartsheet for entire teams that need to work on certain tasks, only to realize that these groups are not automatically included in my contact directory within the sheet itself. Is there a way to assign a row to an entire contact group without adding each individual email to…
-
adding email adress/people into contact group (issue)
Hello everyone. I often create contact group. I used to be able to put any email adress/people I wanted into these contact groups...until today. I created new group today, and for some reason, I sometimes get a message saying "you cannot add this user to this group". This message seems to happen only for specific people…