-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…
-
Countifs only if its a parent row
Hi guys, running into a dilemma where im trying create a countifs for a dashboard for statuses, but I only want the main status from the parent columns and not the tasks. Screenshot shows the status field has multiple in the status "Draft". I'm not super familiar with the children/parent fomula and could use a little help!…
-
Include Hyperlink in Formula where I'm pulling through the parent task?
Hello! Im my sheet I have a formula in a helper column to pull the value of the parent task into each row - our parent task is our project deliverable name and it helps to have that in line for other views / reports. In our parent tasks, we are hyperlinking to our project brief. However, that hyperlink does not pull…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Copying Parent Row into same sheet column of Child Row
Hi, Is there anyway that we can copy parent row into the child row and apply to the whole same column without changing the parent row information? For example: =Parent({Test]@row) works if I put into the child rows only, but when I convert to same column formula the information in the parent row disappears so the…
-
Easy way to copy a nested row into the same sheet
Hello, I'm trying to create a workflow for one of our users to check off when making a new hire, and then when it's done, it'll get moved to an archive. The issue I'm running into is that I can't easily make a template for the users to copy when utilizing the sheet. I want users to be able to stay in this one sheet to…
-
Linking Parent and Subtasks from a sheet into a report
Hi! I am creating a report of tasks that are in various stages, and some of the tasks have a parent/child relationship. I already tried the 'Helper column' to identify parent tasks. Is there a formula to use to identify child tasks? Also - Is there a formula I could use where instead of just listing the Parent Task Name in…
-
Techs Managing their tasks in Smartsheet
We have one master sheet where all of our tasks reside. We use Dynamic view for each tech to review, mange their tasks. However, our Techs would like to organize their tasks in a Heirarchy format. Dynamic View limits that ability. It also limits their ability use the Card view. I set up a heirachy column and conditional…
-
Requesting updates for parent/child rows with dependencies
I have a SmartSheet that I'm using to track my project manager's construction projects they are assigned to. We have some projects for which there are smaller phases that are broken out that I have shown as individual rows set up as child-parent. With dependencies enabled SmartSheet calculates the overall dates of the…
-
Parent roll up function splitting the gaps in child dates
hi Team, New user here on SS. I am wanting to develop a sheet with a gantt chart for my teams leave. It would have categories of the team name and second level category of their names. I was hoping when they add a row for planned leave, it will show in the parent of their name, followed by the parent of the team name. This…
