Technology
Discussion List
-
Smartsheet not saving consistentlyIn Using SmartsheetI have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
-
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 3.1K views 15 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Piechart does not reflect the correct percentage-Showing 100%In Formulas and FunctionsMy pie chart is linked to a cell that says 25% complete. The pie chart says 25% but has (100%) next to it and shows a whole pie chart. I was hoping it would show only 25% of the pie not the whole pie.
-
Webinar recording: Work seamlessly with Smartsheet and Microsoft 365 integrationsIn Using SmartsheetMissed the webinar? Watch the recording here: Work seamlessly with Smartsheet and Microsoft 365 integrations. Increase productivity and real-time collaboration with our Microsoft 365 integrations. In this webinar, we'll share how your org…
-
Need Help with Formula for Rolling MetricsIn Formulas and FunctionsI am working on a 6 months rolling metrics calculation for a point system. A simple data involved will be as follows: 1) Date column 2) Points column (0-10) 3) Name column I need to calculate a 6 months rolling sum of points, for e…
-
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…
-
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…
-
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 ?…
-
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…
