-
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?
-
Board View Performance & Feature Limitations
Hi Smartsheet Team, I’d like to highlight some issues we’ve been facing with the Board View compared to the Card View: Performance Issues The Board View is extremely slow compared to the Card View. Although we prefer the Board View for its features (outlined below), the performance is so poor that we are often forced to…
-
Counting Children Rows if marked as Active
Hello, I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is =COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))
-
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…
-
If the row is a child row then copy parent row's data, otherwise offer dropdown to user
Hi all, Newbie to smartsheets and trying to find a way where I can eliminate redundant user entries for child rows, and offer dropdown of the newly entered row is a parent row: thanks for all your help in advance!
-
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…
-
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…
-
Formula help within a Sheet
Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…