-
When a parent is marked complete how to mark remaining children tasks complete
I have a list that has many parents in the sheet and below that are 4 children tasks. Each have a due date. Not all will need all 4 tasks. How do I have it so when then parent is marked complete it will mark the 4 children tasks complete. This way it will not send notifications if overdue since they will be marked…
-
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
-
Merged: Automation to assign a new row as a child based on criteria
This discussion has been merged.
-
Child Row Formula to Reference Parent Row
Hello! I'm trying to figure out a formula that will always reference the Parent Row. I need all the cells in the Practice Name column to reference the parent row above it. I'm assuming I can't make this a column formula, otherwise the parent row I need to reference will be referencing the parent row above that. So for…
-
How to stop DataMesh breaking % Complete parent row roll-up calculations?
I am trying to use DataMesh to populate my % Complete column using a helper column that provides % completion based on the Status column (because my PM doesn't want their employees to have to enter percentages, but rather statuses). I have the DataMesh config set to copy what's in the helper cell into % Complete. In the…
-
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…
-
Child Auto Numbering per Parent Row
I am trying to find a way to auto generate sequential row IDs for the Child rows of each Parent row. We are doing a sheet per project, with all departments on the sheet, so ideally looking for a column that will auto generate a row ID based on the row position beneath the parent row. Example: CNC Item A1 CNC Item A2 Paint…
-
Hierarchy Help
Hello, I'm trying to create dropdown hierarchys but when I indent under a parent column, the "+" sign goes to the 5th column instead of the first column. Not sure I'm doing it right. It is linked to a form if that has anything to do with it. Thanks!
-
Forumla to checkbox if Parent Row
Hi All, I have a grid which will be used as a timeline function for market planning. I want to only see the parent rows on the timeline so I have tried to set up a formula to checkbox if parent row and filter the timeline that way. I've tried =IF(COUNT(PARENT(Task@row)) > 0, 1) that formula only checks chlid rows. I've…
-
Parent rolling up data in Children rows
Green line is the parent row everything inbetween is children rows Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used. out of the 6 rows, 4 rows have been ticked in appoinment concluded column i want to roll up the count of 4 in…
