At Risk Flag Formula

Hello,

I have a number of "parent rows" with children indented just underneath. Each parent row contains a keyword "launch". I'm hoping someone may be able to assist in a formula.

What I am looking for in theory, if any children indented rows are flagged at risk, the formula would then flag at risk for the parent row. Hopefully I'm making sense here.

3MrQg6VQRMPPmq8wJHMJc2VP6fJhhRpcvqjP6Jc1-2019-08-09_5_58.png

Find more posts tagged with

Formulas

Comments

djpreece

Pretty sure this will work

Add a column to the left of the At Risk column…[New Column]

Parent =if(Sum(children()) > 0,1,0)

Children = if([At Risk]@row,1,0)

Parent [At Risk] cell =if([New Column]@row = 1,1,0)

-dp-

Andrée Starå

Hi,

Try something like this.

Add the following formula to the At Risk column on parent rows.

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

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.