-
Multi Formula/Sheet Help
Hi Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :) I am trying to get a formula to: A) Search a column on another sheet to see if a reference number is present The below works but gives me the total count…
-
When Scanning a Bar Code can it update inventory on the sheet
I wanted to know if there is a way to have inventory get updated either when something is restocked or taken from stock to automatically update the inventory levels when a bar code is scanned or does this need to be done manually? Please assist Thank You
-
Sheet/Report Limitations?
Hi everyone! I was wondering if this scenario is possible for sheets either using formulas or commands. Example, I have 3 sheets (pipelines) that lead to multiple reports. I have jobs ranging from 0-100 (intervals of 20) percent probability(of selling/sold) in the pipelines. I currently have reports that group the…
-
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…
