-
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…
-
How can I exclude "child rows" when executing VLOOKUP?
I am currently trying to update the VLOOKUP formula to exclude child rows. I setup a reference sheet to run the formula, but the only way for it to run properly is to add the child rows. If any child row value is changed, it shows as #NO MATCH, however, I would just like to appear blank. I am currently running the current…
-
Formula for Counting Parent Rows based on a specific column criteria
I need a Countif formula to count the number parent rows that have a specific column value of > 37 , and another formula to count the number of parent rows with the same specific columns value of ,+ 37. Can this be done in the Sheet Summary? The issue is I have Children rows beneath a few Parent rows and I don't want those…
-
How would I edit this formula to only COUNTIFS in a PARENT row?
How would I edit this formula to only COUNTIFS in a PARENT row? I'm not looking to add a helper column. Thanks in advance! =COUNTIFS({THD Team Locked In}, "1", {Billing Month}, Month@row, {APM}, "Emily")
-
Starting with a Sheet, that Now needs to be a Gantt - how does one get roll-up summary info
We started with what we thought was going to be a simple sheet that has grown and now had Target Start and Target End date columns. Now we look at is as a Gantt (again not started as a Gantt sheet) So we made parent and child rows, have the settings in Gantt view looking at these date columns. However, if you indent/make a…
