Automate High formula

Cathy Fraser · 08/19/17

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

Automate High status.JPG

Cathy Fraser · 08/19/17

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 · 08/20/17

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 · 08/21/17

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

Cathy Fraser · 08/23/17

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

Welcome to the Smartsheet Forum Archives

Automate High formula

Comments

Categories