# Reporting: pulling in Parent Rows

edited 06/11/20

Hello,

I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However, the formula does not check parent row even when a subtask is checked. There are up to 5 heirarchy level in some instances, but none are checked. Am I missing something?

=IF(COUNT(ANCESTORS([Task Name]@row)) = 0, IF(COUNT(CHILDREN()) > 0, 1), IF(AND(Start@row >= TODAY(), Start@row <= TODAY(30)), 1))

U

• Brilliant Paul! It worked.

Thank you for the quick response and explanation of the logic.

Cheers,

Usha

• Hello Paul - ran into trouble with the formula. Its checking parent rows even when there isn't a subtask due to start in 30 days. Is there a refinement to the formula that could prevent this? Many thanks

U

• ✭✭✭✭✭✭

My apologies. I just looked at that first part and assumed the rest of the formula was working for you. I didn't even look at the second IF.

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIFS(CHILDREN(), AND(@cell >= TODAY(), @cell <= TODAY(30))) > 0, 1), IF(AND(Start@row >= TODAY(), Start@row <= TODAY(30)), 1))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!