Healthcare
Discussion List
-
Can I hide predecessor lines in a gantt chart?In Using SmartsheetI 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…
-
databaseIn Using SmartsheetHello, 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…
-
Apostrophe added on mass insert thru CDATAIn API & DevelopersHello, 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…
-
Return unique values while ignoring blanks.In Formulas and FunctionsHello! 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…
-
Return status of cell (blank vs. full) at today's date.In Formulas and FunctionsHello! 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…
-
SUMIF failureIn Formulas and FunctionsI'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…Accepted Answer 12 views 3 comments 0 points Most recent by Kimberly Loveless Formulas and Functions
-
How to deselect a radio button answer option in web form?In Using SmartsheetIs 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?)
-
VLOOKUP: How to make into a Column Formula?In Using SmartsheetGood 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…
-
Annual Calendar by Day TemplateIn Using SmartsheetHi, 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…
-
% Variance between 2 numbersIn Formulas and FunctionsI 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?
