-
Dependency from a cell on another sheet
Hello, I run my manufacturing jobs on Smartsheet. I have one sheet with multiple projects on it, Parent row per project and tasks indented I have a few milestone dates in each project for equipment arriving (this date is linked from a shipment tracker) which other task tasks within the project are dependent on before the…
-
Storing documents in a folder, in a Workspace
Looking for best way to share and store documents (Word, Excel, Visio, PDF, etc) inside of a workspace. .. Ultimately, would like to have a tree of folders that will serve as a Data Room for a particular project. Has anyone tackled this previously? Any way to make it work effectively without having to attach to rows and…
-
Forms
Hi There, I am trying to create a form to collect data. But I was wondering if the following things are possible: * How do you change the number of options in a dropdown list, e.g. let say I create a form with a dropdown list of 3 options and then later I want to change it to 4 or more? * Is there an option to select…
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Update Request to Multiple Recipients
I send an update request to 10 people. The request has the 10 recipients listed with text boxes under their names where they will each fill in data and SUBMIT it back to the SmartSheet. It works fine except when recipients go on vacation or are not available to answer the email update request. This holds up the entire…
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…
-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
MS Teams & Smartsheet
Hi all, I've noticed that when using the MS Teams desktop app I'm asked to log into smartsheet each time I want to view the tab, I click on log in and nothing happens. This only occurs with the desktop app, the browser MS Teams app works fine. Anyone else had this issue (screen grab uploaded)
-
Automatic Archiving
I'm creating a weekly schedule in a sheet and I would like to automatically archive that sheet after the week is finished, and save it as the name of that week. Does anyone know how this would be done? Thank you!
-
Maintain dependencies on drag and drop in GANTT view
Hello, I have a support request on drag and drop dependencies. * SMARTSHEET changes the date, if I drag the predecessor bar to the successor bar * SMARTSHHET looses connection of dependencies if I move a connected bar left or right This "simple" described problems can be fixed manually by myself but it's annoying,…