#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Automate High formula

Options
✭✭✭✭✭
edited 12/09/19

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

Tags:

• ✭✭✭✭✭
Options

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", "")

• ✭✭✭✭✭
Options

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", "")

• edited 08/21/17
Options
• ✭✭✭✭✭
Options

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

This discussion has been closed.