Solution Center
Discussion List
-
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…
-
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…
-
How to edit a workspaceIn Using SmartsheetI have been given "Editor-cannot share" permissions by the owner of a workspace but I am unable to make any edits in the shared workspace. When I try to double click on an empty cell, I do not get to edit it. Please advise.Answered - Pending Review 35 views 4 comments 0 points Most recent by Satinder Kaur Using Smartsheet
-
Combine values in column only if value in each row is less than a valueIn Formulas and FunctionsI have a column with an identifier in each row and in another column I have a value in each row. I want to search the second row for any values that are less than a reference cell, and if less that that reference cell, I want the text from…Answered - Pending Review 33 views 1 comment 0 points Most recent by Mike matthys Formulas and Functions
