Parent Flagged if Children Flagged

Hi all.

I have a task list that consist of multiple parent rows with Children

I have modifided so that if a task is delayed or dates are not added in the task will get a flag.

What i would like is to have if one or more of the Cildren Rows are Flagged the parent row will be flagged. but cant figure it out.

Ivé tried with =IF(SUM(CHILDREN())>=1; 1 ; 0)

If any of you could help me out

Find more posts tagged with

Formulas

Comments

Preston

Hey Simon,

I worked up something similar for my own use. I think you could modify it to fit your needs. Have a peek:

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "") >= 1, "Pending CO", IF(COUNTIF(CHILDREN(), "Gray") = COUNT(CHILDREN()), "Gray", "TBD"))))))

Ofir Marco

Hi,

This one worked for me.

on the "Parent" row cells of the flag column i have placed this formula:

=IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0)

Simon Andersson

Hi, tested this and id worked perfect, Thank you!

h1pst3r

Ofir's formula worked perfectly!

Thanks!

-Chris

Ofir Marco

Glad it worked and helped all of you!

jcouncil

@Ofir Marco do you have a suggestion for this formula when when multiple children rows? If flag on any child rows, change parent to flag also. The =IF(COUNTIF(CHILDREN(), =1), 1, 0) works for any parent rows with 1 child row, but it produces #INVALID if multiple child rows with flags selected.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…