Change "Parent" cell based on results of multiple "Children" cells

Hi everyone,

I've been thinking about this for a while and can't determine a viable solution. I have a list of data that has varying amounts of "Children" per each "Parent". An example is that the parents all end in .0 (i.e. 1.0, 2.0, 3.0) and if the values in col D that equate to that parent (i.e. 1.1, 1.2, 1.3, 1.4, etc.) = "Completed", then the parent (1.0) = "Approved". The only issue I seem to be having is that the amount of "children" could vary between each one and could potentially have none. Any thoughts would be appreciated and I have attached an example of what I'm working on. Thanks in advance for any help!

ParentChildExample.xlsx