-
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…
-
I have a column formula applied to a Status Column, however it is not applying to one of the rows.
The column formula is: =IF(Progress@row = "Complete", "Blue", IF(Progress@row = "Upcoming", "Green", IF(Progress@row = "Ongoing", "Green", IF(Progress@row = "Commenced", "Green", IF(Progress@row = "On Hold", "Yellow", IF(Progress@row = "Discontinued", "Red", IF(Progress@row = ".", "", IF(COUNTIF(CHILDREN(), "Blue") =…
-
Parent rows with children in a report to look like a filtered sheet
Hello, I'm looking to have a filtered sheet like experience (picture A below) in a report with a parent and child look, but everything I have tried doesn't get me there. The goal is to have the parent info and be able to expand or collapse the children so they aren't lost at the end of the report when you pull the…
-
Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello, New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate…
