-
database
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 different filters which allow us to manage the record of all this equipment. Currently, if we…
-
Apostrophe added on mass insert thru CDATA
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 apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
Return unique values while ignoring blanks.
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, the bookings flow in like this: Sheet # 1 My goal is now to collect these bookings on a…
-
Return status of cell (blank vs. full) at today's date.
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 dashboard. My test sheet is below: So, to determine whether Desk 1 is occupied or…
-
SUMIF failure
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 production numbers are added and the metric will be calculated. I created the sheet…
-
How to deselect a radio button answer option in web form?
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?)
-
VLOOKUP: How to make into a Column Formula?
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 Pierce
-
Need Formula: Per Facility per Model #, how much +/- from par level.
I need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Is there a way to download SmartSheet form as a PDF?
I want to be able to use Smartsheet form as a PDF also in cases where I have to manually write information or use the form as a Job Sheet for Complaint/Servicing form. How can I do that? Any help will be greatly appreciated.
