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…
    1156 9
    1.2K views 9 comments Most recent by Samuel Needleman Using Smartsheet
  • 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…
    41 3
    41 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…
    172 6
    172 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…
    11 5
    Accepted Answer 11 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Return status of cell (blank vs. full) at today's date.
    In Formulas and Functions
    Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS da…
    1 2
    Accepted Answer 1 view 2 comments Most recent by Clayton Richards Formulas and Functions
  • SUMIF failure
    In Formulas and Functions
    I'm trying to improve a labor intensive process (40+ spreadsheets that do not interact) to calculate a a weekly production metric by Examiner. Basic workflow is that Examiners enter time worked in various categories daily, then once a week…
    12 3
    Accepted Answer 12 views 3 comments Most recent by Kimberly Loveless Formulas and Functions
  • How to deselect a radio button answer option in web form?
    In Using Smartsheet
    Is there a way to allow a user the ability to deselect (or unselect) a radio button option after making that selection (i.e., clear out their choice and make no selection after already having made the selection?)
    459 3
    459 views 3 comments Most recent by Sandra Guzman Using Smartsheet
  • VLOOKUP: How to make into a Column Formula?
    In Using Smartsheet
    Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley…
    11 3
    Accepted Answer 11 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Annual Calendar by Day Template
    In Using Smartsheet
    Hi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the current calendar, the formula is not ea…
    81 4
    81 views 4 comments Most recent by Sue Hill Using Smartsheet
  • % Variance between 2 numbers
    In Formulas and Functions
    I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
    816 6
    816 views 6 comments Most recent by Andrew Kuhn Formulas and Functions