Discussion List

  • COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
    In Formulas and Functions
    @Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, wh…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • COUNTIF & Multi-Selection Dropdown -- Count multiple entries
    In Formulas and Functions
    My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple *…
    Answered - Pending Review
    2115 13
    Answered - Pending Review 2.1K views 13 comments Most recent by Paul Newcome Formulas and Functions
  • Create Chart Widget Using a Report (not a Sheet)
    In Using Smartsheet
    With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the sub…
    1647 10
    1.6K views 10 comments Most recent by Genevieve P. Using Smartsheet
  • Editing multiple sheets at once
    In Using Smartsheet
    Hi, I've been working with over 50 sheets in a workspace. Each sheet contains info of a different country. Now if I make a change in one of the columns in a sheet, I have to replicate the change in each of the files individually. Is the…
    458 5
    458 views 5 comments Most recent by Angie M Graham Using Smartsheet
  • Automated Workflows Limit
    In Using Smartsheet
    Hi  Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.  
    569 5
    569 views 5 comments Most recent by Leslie Merlino Using Smartsheet
  • Auto populate data in Forms
    In Using Smartsheet
    I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
    2385 13
    2.4K views 13 comments Most recent by Andrée Starå Using Smartsheet
  • how can add multiple approval request in the same row and cell using workflow?
    In Using Smartsheet
    I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i can add multiple items in one time to approved(in item code column). How can it possible ?…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by mystery Using Smartsheet
  • Can I populate Smartsheet rows from a SQL Database read?
    In API & Developers
    I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
    Answered - Pending Review
    1050 6
    Answered - Pending Review 1.1K views 6 comments Most recent by Richard Rymill SBP API & Developers
  • Formula for percent match to a multi select column
    In Formulas and Functions
    Hi, I'm working matching mentors and mentees.  We would like to match them based on attributes they both selected in a multi select column.  As in, choose your top three competencies.  Now I would like to make a formula to determine the pe…
    112 9
    112 views 9 comments Most recent by Pam Ferguson Formulas and Functions
  • % Allocation
    In Using Smartsheet
    As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
    EdL Profile Photo EdL
    1592 8
    1.6K views 8 comments Most recent by Sylvain Martel Using Smartsheet