Sign in to join the conversation:
How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
Put a period, or any text, in the parent rows. Then color the letters the same as the background color. You can do this manually, but if you have a bunch of rows like that, you may want to create a formula and tell it to show a period if it's a parent row- which you'd need to define based on the criteria on your sheet which defines the parent rows.
Thank You, that worked like a charm.
Hi Mel,
I use this one all the time in my client solutions. I name the column Level and use that to simplify conditional formatting and more.
Try something like this.
=IF(COUNT(CHILDREN([Task Name]@row)) > 0; COUNT(ANCESTORS()) + 1)
The same version but with the below changes for your and others convenience.
=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
As a basic outline, I have column 1, 2, and 3. Columns 1 and 2 list 4 identical options: A, B, C, D in a drop down menu. Essentially, I would like column 3 to calculate/display the difference between columns 1 and 2, removing a duplicate. For example: Column 1: A, B, C, and D are selected in the drop down Column 2: B is…
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
