-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Does anyone have any great manufacturing process systems
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to refresh our processes. It is time to do this so any shared ideas would be great.
-
Locked rows not picked up by automations
Hi all, I have a spreadsheet with just 4 columns, and i have a set of rules to apply to them. One of those rules is sending Update requests if the date column is over 7days in the past. But, since the spreadsheet will have "countless" rows, i want the rows that had Update requests before, to be locked (easy part) after the…
-
SUMIFS Statement under Parent Item
I need to Sum the "Total" column cells IF: 1) Column Department Allocation Code = "49 CONTINUOUS IMPROVEMENT: Formula: =SUMIFS(Total:Total, Department Allocation Code:Department Allocation Code, ="49 CONTINUOUS IMPROVEMENT", Item:Item, =PARENT(Item1)) *Not working <img alt="" data-entity-type="" data-entity-uuid=""…
-
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…
