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

Meenakshi Sundaram S · 03/07/18

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 · 03/07/18

=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 · 03/08/18

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

Comments