-
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?
-
Hierarchy Formula
Hello! I've been trying to count how many milestones called "Testing" with %Complete = 100% are per project. Each milestone is a child of a parent called "Milestone" and this is at the same time a child of the project name. At the end, each project is a child of a big project name. (I've attached an example of the…
-
Use date and status to define RYG balls
Hey all, Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball. If end date is today or later, AND status is not complete or cancelled, green If end date is today -1, AND status is not complete or cancelled, yellow If end date is today -2 or…
-
Count dropdown and %
Hi Community, I am defining the following formula to count how many children cells are blank out of the total number of children cells along with the associated percentage value. In a Team schedule sheet this will count how many time slots are still available. The cell visualisation would be: 16/25 (64%) The problem is the…
-
Why is INDEX slow?
Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those columns have formulas. These sheets now use summary fields, some of which derive their…
