-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
Merged: Contact List Dropdown
This discussion has been merged.
-
Copying Emails from Outlook into Contact Cells in Smartsheets
I'm sure there is a simpler way to do this, but I'm not sure how. I want to copy and paste emails into a contact cell in my Smartsheets. When I copy them from out look it retains the format like this and doesn't recognize that person as a Smartsheet contact. Obviously, I can type in the names and their contacts will come…
-
Copying and Pasting Contacts From Outlook
Smartsheet should implement the ability to copy and paste contacts directly from the "To" or "Required" fields within Outlook. If the system already has the contact listed it can match them to that existing entry. However, if the contact is new it should automatically use the information copied to create an entry. When…
-
Adding contacts on an organization level
Is there a way to add contacts on an organization level so that the contact list will be the same for all users in an organization? If it isn't possible, is there a way to quickly add this on a workspace level? (Without having each user add it on their 'My Smartsheet Contacts' manually each time)
-
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…
-
Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…
-
How to create a contact group
Dear community, kindly seeking for your help to find the way how to create a group of contacts (or a way to add a pre-created User Group) in a drop down list in "Send update request" function during "select contact" drop down list. Hope my question is clear as english is not my native language.
-
Merged: Dynamic Contact lists - User groups to populate dropdown and/or forms to reference user lib…
This discussion has been merged.
-
Return multiple contacts based on department dropdown list.
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…