Check if a row is parent and starts with "abcde"

Meenakshi Sundaram S

Hi,

Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".

Jack SSCR

=IF(AND(LEFT(PARENT(), 5) = "abcde", COUNT(CHILDREN()) > 0), "Y", "N")

Change Y or N to what you need, depending on whether the formula meets the criteria.

Note that this will only check for children in the same column

Meenakshi Sundaram S

Thanks for this. Is there a way to find if the PARENT OR the GRANDPARENT has the word "abcde"?