Discussion List

  • 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 …
    12 3
    Accepted Answer 12 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
    231 8
    Answered - Pending Review 231 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…
    1195 16
    Accepted Answer 1.2K 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…
    21 2
    Accepted Answer 21 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…
    1515 9
    1.5K 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…
    1372 11
    1.4K 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
    21 5
    Answered - Pending Review 21 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…
    13 1
    Accepted Answer 13 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…
    296 2
    296 views 2 comments Most recent by Joachim Mund Using Smartsheet
  • Sharing a sheet with a user with 2 different emails
    In Using Smartsheet
    I have shared a sheet with a list of people. They are all in my contacts. Now, they are transitioning to a new email. I added their new emails to my list of contacts but when I try to share the sheet with them, their contact with the new e…
    11 2
    Accepted Answer 11 views 2 comments Most recent by AnneSophie Using Smartsheet