I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having …
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update…
Hello all, I'm trying to build a sheet that notifies the right person when certain new records are entered (e.g. alert Person X when a new record is entered that has a certain column equal to ABC). In…
I was going to create a column and lock it/and hide it - this column will hold all of my formulas. When a row is moved to another sheet, will my locked column stay put? I need to hide my formulas some…
Hello, I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found).. I…
I have a sheet that lists employee data, that links to a table of assigned managers. Next I have a report for each manager that pulls current employees data, this has been great; however I have begun …
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to S…
What's the best template to track multiple orders from multiple people. We've tried uploading PDFs to rows but can't capture totals of each product. Drop down menus could work, but no way to add in qu…
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several oth…
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i cho…