Discussion List

  • 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…
    2218 13
    2.2K views 13 comments Most recent by Andrée Starå Using Smartsheet
  • Prevent Overwriting of "Handler" Column
    In Using Smartsheet
    Hello, We have a smartsheet for our support team to claim requests submitted. As of now, when a form is submitted- every member of the support team receives an alert. From there, one of them must enter the sheet and elect themselves to han…
    45 3
    Answered ✓ 45 views 3 comments Most recent by Jess Bowles Using Smartsheet
  • Using Contact List data in IF statement in Sheet Summary
    In Formulas and Functions
    I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sh…
    37 3
    Answered ✓ 37 views 3 comments Most recent by wdpassport Formulas and Functions
  • Dashboard - Embedding links to email addresses
    In Using Smartsheet
    I've seen some past posts on this topic but have not gotten the workaround to work and was hoping that there may be progress on a solution. At the 2020 Engage event, I saw a beautiful dashboard that had images and email links under a title…
    884 7
    Answered ✓ 884 views 7 comments Most recent by Kevin_KK Using Smartsheet
  • Automation Workflow Sequencing for E-mail Notifications
    In Using Smartsheet
    Hello, I've been rolling out some new sheets/processes to my colleagues and I've run into a little snag that I'm hoping to seek clarification from you awesome Community members. Scenario 1: I have an input form that will automatically assi…
    Answered - Pending Review
    46 4
    Answered - Pending Review 46 views 4 comments Most recent by Jake Gustafson Using Smartsheet
  • Auto Reply to Form Submissions
    In Formulas and Functions
    Hello Team, I was trying to setup automatic replies to people who enter their email and select a certain timeframe. I would then like to send an automatic reply with information regarding the session that they signed up for. Is this possi…
    68 4
    Answered ✓ 68 views 4 comments Most recent by Brenda Formulas and Functions
  • How to identify if Contact -OR- Text is in a Contact column?
    In Formulas and Functions
    Hi everyone - We have starter task templates that we use when we initiate certain types of work. The templates have a Contact List column that is initially populated with ROLES (e.g. project manager, designer, tester, etc). The ROLES a…
    Answered - Pending Review
    74 4
    Answered - Pending Review 74 views 4 comments Most recent by SJ Sellers Formulas and Functions
  • Contact List Clean-up
    In Using Smartsheet
    Hi, I'm new to a company, and new to their sheets as well and in trying to clean up an older sheet of existing consultants, it has former consultants listed and they get populated in the weekly schedule occasionally. I can't seem to delet…
    Answered - Pending Review
    39 1
    Answered - Pending Review 39 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Combine two separate contact cells into one cell.
    In Formulas and Functions
    With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
    1601 13
    1.6K views 13 comments Most recent by Robocop55 Formulas and Functions