Technology
Discussion List
-
COMPLEX INDEX/MATCH arguments issue: Project Updates TasklistIn 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 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entriesIn Formulas and FunctionsMy 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 2.1K views 13 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Create Chart Widget Using a Report (not a Sheet)In Using SmartsheetWith 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…
-
Editing multiple sheets at onceIn Using SmartsheetHi, 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…
-
Automated Workflows LimitIn Using SmartsheetHi 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.
-
Auto populate data in FormsIn Using SmartsheetI 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…
-
how can add multiple approval request in the same row and cell using workflow?In Using SmartsheetI 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 ?…
-
Can I populate Smartsheet rows from a SQL Database read?In API & DevelopersI 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 1.1K views 6 comments 0 points Most recent by Richard Rymill SBP API & Developers
-
Formula for percent match to a multi select columnIn Formulas and FunctionsHi, 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…
-
% AllocationIn Using SmartsheetAs 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…
