Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
 

Discussion List

  • Announcement

    New! Add real-time validation to fields on your form
    In Product Announcements
    Hi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, percentages, email addresses, and phone num…
    Accepted
    82 10
    Accepted Answer Announcement 82 views 10 comments Most recent by Olivier LEMBERT Product Announcements
  • Index and match using dropdown, multi select column.
    In Formulas and Functions
    Hello, I want to index and match off of a dropdown, multi-select column. If there are multiple selections in the dropdown I would like the project name to appear next to each individual name so that I can track assignments by the individua…
    Accepted
    44 4
    Accepted Answer 44 views 4 comments Most recent by Genevieve P. Formulas and Functions
  • Automation Question
    In Using Smartsheet
    Hello Smartsheets Community: I was working on a couple of automations in a project plan that I am working on and I thought of one that could be useful. Being able to run an automation when a hyperlink is added to a task requiring work on …
    Accepted
    13 7
    Accepted Answer 13 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • formula - contains
    In Formulas and Functions
    hi Guys i am trying a contains formula but doesn't want to work - what am i doing wrong? i need my REF column to get a 1 in if IF Dept contains REF if not REF then blank
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Problem with % format in a cell
    In Formulas and Functions
    I have a cell in a summary sheet in which I am using a JOIN function simply to pull from another sheet. The cell in that sheet properly displays the data in a percent format (%) However the cell in my Summary sheet, displays the linked inf…
    Answered - Pending Review
    9 4
    Answered - Pending Review 9 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Form creation
    In Using Smartsheet
    Hi All Thank you in advance for taking the time to look into my issue. I need t to create a form to collect information, but I have an issue with the "registered mark" Is there a way to work around this? Masterpiece® Contact For…
    Answered - Pending Review
    6 3
    Answered - Pending Review 6 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Math formulas across multiple cells
    In Formulas and Functions
    Hello all, Any help on the following issue would be very much appreciated. I have a scoring matrix built in to Smartsheet (See below). I would like to multiply the score of each cell for each criteria (Strategic Init Impact Score, Busines…
    Accepted
    16 13
    Accepted Answer 16 views 13 comments Most recent by Kathryn Pineda Formulas and Functions
  • need a formula
    In Formulas and Functions
    hi Guys, me again, need a formula to count my netdays if Pass/Fail is a fail..... if a pass do nothing
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
    In Formulas and Functions
    I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don'…
    Unresolved
    15 3
    Question 15 views 3 comments Most recent by CAI-RAS Formulas and Functions
  • COUNTIFS with DISTINCT
    In Formulas and Functions
    This discussion was created from comments split from: Countifs with Distinct?.
    Answered - Pending Review
    6 2
    Answered - Pending Review 6 views 2 comments Most recent by Andrée Starå Formulas and Functions