-
Complete Through Progress Bar
My organization is moving from MS Project to Smartsheet and there is a functionality on the progress bar of the gantt chart in MS Project that I would like to see if Smartsheet can do. The Update Progress bar that shades % Complete in MS Project can be set to show Complete Through progress (the functionality is detailed in…
-
Subtract List Of Parts from Inventory
Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, which I list in the "Products parts list", for example: Product #1 requirements = 2 Wheels, 1 axle, and 2 wires. And the way I have set it up now, every time when I sell…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?
-
Help needed with averaging RYGB balls of children cells
Hi, I wanted to know how I can average the RYGB balls of the children cells. Something on the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow. If there are no reds and yellows, and at least one green, turn the parent green. If all the balls…
-
How to Calculate Standard Deviation in a smartsheet?
Hi, I'm working on getting all metrics for a large project into a dashboard in smartsheets. I've been tracking a burn up chart in google sheets, but think that connecting directly to it doesn't look clean. So in an attempt to copy it over, I'm starting from scratch but can't seem to find how to do standard deviation as a…
-
How to pull assigned task from differnt workspaces into a master task sheet
Each of my clients has their own workspace with multiple sheets. One of the sheets is a project planner/task list, where each task is assigned to an employee. We have 50 + clients and you have to go into each workspace and click on the project planner/task sheet to keep up with what is assigned to you. Is there a way to…
-
Automated calendar
Is there a way to create an automated appointment link like travel sites do once you book your dates? I created a webform for Time Off requests for our Sr. Managers. I would like to be able to send them a link to add the request to their calendars once it is approved.
-
Adding Time to a Project Plan via Forms
I have a normal/typical/simple project plan sheet: task, duration, assigned to. In lieu of having the Proj Mgr ask the engineer, how much he accomplished on the task and then putting that time into the project plan manually, is there a way that I can give a form to the engineer, that includes a dropdown that reads the…
-
Adding Formulas to Predecessors Column...Or Is there a Workaround?
Hi there, Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :) Up until now, I've been able to use the Predecessors column with ease, for e.g. 1FS + 5d, meaning that the project on the 2nd row will…
-
Milestone coloring and Multiple Label Options
Can you add these features this year?