Discussion List

  • Can I hide predecessor lines in a gantt chart?
    In Using Smartsheet
    I have a complicated project with tons of predecessors.  The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use.  Is there are way to hide or turn off not the predecessors, but…
    1365 10
    1.4K views 10 comments Most recent by Jenna123 Using Smartsheet
  • Recommended format
    In Using Smartsheet
    Hi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have ab…
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Outlook Integration not installing
    In Using Smartsheet
    Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added&…
    76 5
    76 views 5 comments Most recent by msfeltontoth Using Smartsheet
  • I'm trying to create a form to be used to evaluate if a product is acceptable or not.
    In Using Smartsheet
    I'm trying to create a form in Smartsheet that would look similar to this below. Is this even feasible at this point with Smartsheet? First column is the product being evaluated, and we are asking clinicians to check either acceptable or …
    Answered - Pending Review
    14 6
    Answered - Pending Review 14 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Finding 'send' history form a row
    In Using Smartsheet
    Hi - Is there a way to see what was sent when using the function "Send" when selecting a specific row?  I see the activity log notes some information, but I don't see this anywhere. Am I missing it?  Is it a better practice to al…
    759 5
    759 views 5 comments Most recent by BJS Using Smartsheet
  • How to count children rows with multiple criteria
    In Formulas and Functions
    I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases ID…
    75 5
    Accepted Answer 75 views 5 comments Most recent by Jennifer Petty Formulas and Functions
  • Creating a Master Project List and Dashboard
    In Formulas and Functions
    Hello, I would like some help in designing  a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to…
    233 4
    233 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • database
    In Using Smartsheet
    Hello, Smartsheet team! I work for a medical equipment sales company which is intereted in create a database of all our client’s equipment. We want to sort all this information out in order to eliminate paperwork. We need to apply differe…
    55 3
    55 views 3 comments Most recent by Mr. K Using Smartsheet
  • Apostrophe added on mass insert thru CDATA
    In API & Developers
    Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an a…
    219 6
    219 views 6 comments Most recent by Jeff Zumaris API & Developers
  • Return unique values while ignoring blanks.
    In Formulas and Functions
    Hello! I'm trying to find a function similar to vlookup or index that will return a unique value where there are duplicate search values. In this example, individuals book a desk on a given date. Since form submissions create a new row, th…
    27 5
    Accepted Answer 27 views 5 comments Most recent by Paul Newcome Formulas and Functions