Solution Center

Discussion List

  • Indenting on smartsheet causing calculation error- help?
    In Formulas and Functions
    Hello, 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 …
    Accepted
    24 3
    Answered ✓ 24 views 3 comments Most recent by Heather Duff Formulas and Functions
  • Form - Copy of Answers
    In Using Smartsheet
    Hello, 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…
    Answered - Pending Review
    66 1
    Answered - Pending Review 66 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
    In Formulas and Functions
    There 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…
    203 5
    203 views 5 comments Most recent by Shile Formulas and Functions
  • Extract multiple pieces of a text string that meet a criteria - between parentheses
    In Formulas and Functions
    I 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…
    Accepted
    98 10
    Answered ✓ 98 views 10 comments Most recent by Paul Newcome Formulas and Functions
  • Docusign Integration - Attach final Envelope as separate docs?
    In Apps, Integrations, and Add Ons
    We 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…
    Accepted
    44 2
    Answered ✓ 44 views 2 comments Most recent by Kayla Apps, Integrations, and Add Ons
  • Large criterion name
    In Formulas and Functions
    Hello, 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…
    Accepted
    24 4
    Answered ✓ 24 views 4 comments Most recent by Kelly Moore Formulas and Functions
  • extract part of a cell's text
    In Formulas and Functions
    Hello, 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…
    3606 3
    3.6K views 3 comments Most recent by Heather Duff Formulas and Functions
  • How to edit a workspace
    In Using Smartsheet
    I 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 4
    Answered - Pending Review 35 views 4 comments Most recent by Satinder Kaur Using Smartsheet
  • Combine values in column only if value in each row is less than a value
    In Formulas and Functions
    I 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 1
    Answered - Pending Review 33 views 1 comment Most recent by Mike matthys Formulas and Functions