-
Formula to sum children rows into parent row
Hi Is there a formula to add up total hours for children into Parent row cell? Also to add earliest local start time and earliest local finish time in parent header?
-
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…
-
Enhance Row Collapse Functionality for Improved Project Management
Our team manages a large number of projects on a single Smartsheet, with each project containing multiple child rows to track weekly progress and phases. This results in an extremely long sheet, making it challenging to navigate and manage efficiently. Our management prefers to have all projects and phases listed on one…
-
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…
-
Parent-Child Count distinct children under a specific date and type parent
Hi everyone, I'm trying to establish a parent shild structure that will help me count total number of distinct children under a parent when two conditions of parent are met. Below is an example grid. I'm loking for a formula that will count the number of disticnt children that are listed under parent that are Blue and…
-
Display only parents in card view
i have parent rows with children and i have used a formula to identify the parents. i want to use a filter so that when viewing Card View i only see parent rows and NO children. i cant figure out how to do it. even when i filter using my "is parent" (=1) column i get more than that
-
How to pull the top parent to the row
I need a way to consistently pull the top-level parent to all rows below for our reports. Here's an example: In this case, all of the apples need to have "Alpha" on their row. Similarly, all of the variations of Ed, Edd, and Eddie, as well as Easy and Edison, need to have "Echo" on their row. So on and so forth. Right now,…
-
Merged: Parent and Child Rows in filtering
This discussion has been merged.
-
How to calculate parent-level values in multiple columns (not just % Completed)?
Hi, In my project sheet, only the % Completed column rolls up automatically using parent/child logic. That works fine. But I want to do something similar in other columns, like: Variance from Baseline (%) Weighted Variance Planned Progress (%) These are all calculated row by row, but I want to show an accurate value at the…