-
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…
-
Automatically Update Grandchild Status when Child Status Changes
Hello, I feel like I'm making this formula much more difficult than it needs to be (I'm totally overthinking it!). Anyway, I have a sheet that has Grandparent, Child and Grandchild rows. When the Child status changes to "closed", I want the status for the grandchild to update to "closed" Does anyone know any easy formula…
-
Vlookup formula help
Hello - I created a summary sheet using the vlookup formula referencing another sheet. However, how do I show two amounts from two different rows in the source sheet where one row is the parent and one row is the child? I got it to show one of the values (the one from the PARENT row), but I need it to show both amounts in…
-
Parent & Child Formulas in the Same Column?
My sheet is structured as a sort of tiered task checklist. There are several Parent rows with varying numbers of Child rows. There are two columns that are involved with my issue: the first is a "Status" column, and the second is a sort of "True/False" binary check labelled as "% Complete." There are no formulas in the…
