Discussion List

  • Creating a Group
    In Using Smartsheet
    Hi I want to give my whole firm access to a particular smartsheet item. Is there a way to bulk upload contacts into a group without any additional add-ins / different licence? I have access to our admin centre and have created the group I…
    14 3
    Accepted Answer 14 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Contact Card email address fo automation
    In Using Smartsheet
    Hi All, I have a sheet where customers send a submission and get automated emails with field data that they submitted. I want to provide details of the assignee of their submission but want to provide the assignees email address stated on …
    11 3
    Accepted Answer 11 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Copying contact information from one sheet to another
    In Using Smartsheet
    If my users attempt to copy contacts from one sheet to another, they loose the total contact information. Only the name, as text comes over. Even if both column types are Contact. There does not seem to be an easy way to copy over a list …
    Answered - Pending Review
    184 8
    Answered - Pending Review 184 views 8 comments Most recent by Rob Oaks Using Smartsheet
  • Contact List - Extract First / Last Name?
    In Formulas and Functions
    Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there…
    1023 16
    Accepted Answer 1K views 16 comments Most recent by Paul Newcome Formulas and Functions
  • Can I create a "No-Reply" user within Smartsheet to send external forms?
    In Using Smartsheet
    I am creating several forms and automated email alerts that will go to external resources and I do not want my name attached. Could I possibly create a "No-Reply" user in Smartsheet and transfer the sheets to this user? I under…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by bhealey77486 Using Smartsheet
  • Contact list in forms
    In Using Smartsheet
    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…
    1343 9
    1.3K views 9 comments Most recent by Jamie Bedford Using Smartsheet
  • COUNTIF Formula for Contact Column
    In Formulas and Functions
    I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
    1297 11
    1.3K views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Can a Contact column populate based on selection in another cell?
    In Formulas and Functions
    I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workst…
    Answered - Pending Review
    11 5
    Answered - Pending Review 11 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Unlicensed unable to receive verification email
    In Formulas and Functions
    I have an unlicensed user who inputs data into my smartsheet. He is supposed to received a confirmation email once his form submission has gone through with a copy of the data that he entered for his records. He is one of many employees w…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Data storage EU
    In Using Smartsheet
    Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Ger…
    255 2
    255 views 2 comments Most recent by Joachim Mund Using Smartsheet