Solution Center
Discussion List
-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?In Formulas and FunctionsI am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tri…
-
How can I count distinct values under a same month?In Formulas and FunctionsHi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this …Answered - Pending Review 95 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Indenting on smartsheet causing calculation error- help?In Formulas and FunctionsHello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my …
-
Form - Copy of AnswersIn Using SmartsheetHello, Is it possible for a form submitter to receive not just their answers, but also a copy of what they filled out? Our form has information in the question descriptions (not just the Q&A fields) that we'd like them to have a copy o…
-
Removing Rows at Bottom of Sheet - Affecting Formulas on DashboardIn Formulas and FunctionsThere are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our d…
-
Extract multiple pieces of a text string that meet a criteria - between parenthesesIn Formulas and FunctionsI want to extract both the 1234 and 4567 from this text string: "First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it" I am able to pull the 1234 wi…
-
Docusign Integration - Attach final Envelope as separate docs?In Apps, Integrations, and Add OnsWe are using a Template Docusign Envelope (with multiple documents in the envelope) and sending that via Smartsheet Generate Docs Docusign Integration. When the doc envelope is complete, the document attaches as one combined PDF in Smartsh…
-
Large criterion nameIn Formulas and FunctionsHello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the…
-
Automated workflow trigger not workingIn Using SmartsheetI have set up a series of simple workflows to change a cell's value based on data in another cell. If the source cell value is changed to "50%" for example, the destination cell will automatically be updated with the number 5. …
-
extract part of a cell's textIn Formulas and FunctionsHello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another e…
