-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
Importing Excel Spreadsheet with embedded formulas
Does anyone know if you can import a Excel spreadsheet into SmartSheet with embedded formulas and formulas linked to other sheets in the same Excel file without having to re-create the formula within SmartSheet?
-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Average of a drop downbox item
Hello, I am currently working on a project that involves a Dropdown box that has 3 options, Not Started, In-progress and Completed. However, I would like to get the average status of the project, and the the formula I am currently using doesn't seem to be working properly so I was wondering if I could have some help. This…
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Sorting Filtered Sheet
Does anyone know if there is a way that you can sort a filtered sheet without altering the sheet structure across the board? Thanking you in advance.
-
My Cell is Red for NO Reason!
The title says it all. I have a cell, inside a column (obviously lol), and its red. I have no idea whatsoever why it is red. Is it mad at me? (lol okay, no more jokes I promise) I do have lots of conditional formatting in my sheet, and in this column too, but the other cells are behaving as expected. I tried satisfying the…
-
Inserting Barcodes
So - I see the new bar code functionality. However, I don't see information that describes how you would insert a bar code into a sheet (I assume it has to be done so that the search function works). This may be super simple, but I'm a bit lost. 1. What is the best way to generate one? 2. How do you transfer the bar code…
-
Copying Alerts & Actions from sheet to sheet
Hi all, I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets. Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet? Thank you.
-
FILTER
Hi, Im struggling to find a way to filter and select.. Just as in excel, i want to be able to filter where it shows all say companies and then tick a company name to allow me to see all the entries starting with that company name. Hope this makes sense