-
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,…
-
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
Hello All, I am trying to write a formula on a Status column. the conditions are: Not Started if planned start date is in the future and actual start date is blank. In Progress if actual start date is not blank and its not pasted planned start date Delayed if actual start date is blank and today's date is passed planned…
-
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…
-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Roll up Fail
I have a test scenario as a parent and a sub-task as a child. So let's say, I have 11 sub tasks under the parent, if one of those 11 children has fail in its status, the parent will say fail. If all say pass, then the parent will say pass. I couldn't get the formula to work what I wanted it to do.
-
Add copied row as a child row
I have a row being copied via "Manage References" using INDEX MATCH from Sheet 1 to Sheet 2. If this row matches the project number and has a ".0" indicating added task to the same project, I want this row to be copied over as a child to the Parent row in Sheet 2. Currently it just lists it as a new row. Below is the INDEX…
-
Parent and Child Rows in filtering
There should be a way to toggle option if we want to include child rows inside of a filter. Where we can currently have the parent row option, we should be able to also include child rows.
-
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
-
Status Rollup to Parent Formula
Hi, I have this formula that works when automating parent/child tasks in a project plan. =IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@row)), "Complete", IF(COUNTIF(CHILDREN(formula@row), "Not Started") = COUNT(CHILDREN(formula@row)), "Not Started", "In…
-
Is it possible to add child rows to multiple parent rows with a single API call?
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attributes for every child row. I am consistently getting errorCode 1123 when the program moves from the first parent row to the…
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
Generate child rows from form and link to a specific Parent
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just discovered, I don't like the way it works. Below is the template I pulled. The last 2 records are what I entered via the…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
-
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
-
Ideas on how to handle complex projects with LOTS of sub-tasks
I am working with on of our departments internally on their Smartsheet system, and looking for insight into how some of you handle complex project plans. What they have right now is so bloated that it is unmanageable, and making them rethink using Smartsheet as a system at all. for context, they went from using Google…