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 co…
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 …
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-1…
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 tha…
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 …
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
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 …
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 s…
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 cond…