Another parent-child condition format scenario
I've search Community and found several very excellent formulas that fall into the parent-child conditional format category; however, they rely on a checkbox type to function. In my scenario, the child row has a conditional format that when a date is within 15 days of target date, the row is highlighted. I'd like the parent row to adopt the child condition when applicable.
For example, child sub-task has a target date of 4/3/18. Within 15 days of this date, a conditional format applies to the sub-task row. I want to apply this same condition to the parent row. When I apply a formula such as =if(ColumnName1<today()-30),1,0) and parent formula =sum(children())*(-1) gleaned from Community, it parses out, blocked, etc. How can I build the formula to use a date type?