-
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…
-
How do I include Contact List Columns in Concatenation?
I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it to just read the name in the contact for that cell as text?
-
Contact Lists and Formulas
Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job. The formula works for inputing the right name, but only as text. Is…