-
Copy folder error
I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with the reference data for that location. I've "saved as new" the folder and gotten an…
-
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…
-
Auto fill information in sheet when a check box is checked in a different sheet?
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?
-
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…
-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…
-
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…
-
At Risk Flag triggered by upcoming due date and/or past due, and % complete less than 100%
Hi, I'm looking for formula help with the at risk flag. Goal: If target finish date is within 7 days OR past due, and % complete is less than 100%, then activate flag. when % complete equals 100%, flag can deactivate. =IF(AND([Target Finish Date]@row <= TODAY(7), [Target Finish Date]@row >= TODAY(), Status@row <>…
-
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…
-
Move or copy row workflow results in empty rows in destination sheet
I have set up a few workflows that copy rows from an interim calculation sheet into a destination sheet for history/time series purposes. Whenever I set this up, I run a few test cases to make sure it working okay before I let the scheduled workflow take care of this automatically. This means, I have a few test rows that I…
-
Calculate total of each entry from multiple drop down selections.
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached. In my metrics sheet, I want to find out the total number for each entry. When I put 'countif' formula, it only considers…
