Automate High formula

Cathy Fraser

Hi, I am trying to automate a trigger that looks at a WBS and if it has a High Status in the form of a ! mark, that it in turn auto triggers the some status in the top WBS name line. 

See attached screenshot. 

 

Thanks 

Cathy

 

Cathy Fraser

I now have the formula that works on one cell, but I need it to look each WBS cell

=IF([Over Due WBS]6 = "High", "High", "")

I have tried the below, but it does not work

=IF([Over Due WBS]6:[Over Due WBS]13 = "High", "High", "")

Cathy Fraser

Ok, I have come up with the below formula...is there a shorter formula that could be used? if not this is the one

=IF(OR([Over Due WBS]24 = "High", [Over Due WBS]25 = "High", [Over Due WBS]26 = "High", [Over Due WBS]27 = "High", [Over Due WBS]28 = "High", [Over Due WBS]29 = "High", [Over Due WBS]30 = "High", [Over Due WBS]31 = "High"), "High", "")

 

MattH

Take a look at this post: https://community.smartsheet.com/discussion/countifchildren-criteria 

Cathy Fraser

Just in case some one else is looking for the some formula, this is what I went with 

=IF(COUNT(CHILDREN()) > 0, "High", "") - Will show ! mark 

=IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0) - will show a flag