We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Inst…
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 Prog…
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 …
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…
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 th…
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 c…
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 i…
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 th…
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 th…
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 n…