Welcome!

At Risk Report with parent and only some select rows

Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.

Find more posts tagged with

Formulas

Reports

Legal

Project Management

Comments

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

There are a few ways to do this. The easiest way would be to use a checkbox column and write an IF statement to establish your criteria. You could then build your report to pull all rows where the box is checked.

=IF(AND(COUNT(CHILDREN([Item Name Column]@row)) > 0, [Actual Cost Column]@row > [Budget Column]@row), 1, IF(AND(COUNT(CHILDREN([Item Name Column]@row)) = 0, [Total Column]@row > 0), 1))

First it will look to see if the row has any children rows. If it does and the Actual is greater than the Budget, it will check the box.

If the row does not have any children rows (meaning it is itself a child row) and the Total is greater than 0, it will check the box.

You can then build your report to pull all rows where the box is checked, and it will automatically be sorted with the parent row above the children rows.

Sign in to join the conversation!

Quick Links

Trending discussions

Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.