How to FIND if the grandparent or parent has a particular word

Meenakshi Sundaram S

Hi,

 

Is there a way to find the Grandparent or Parent has a particular string/word?

I have tried PARENT(PARENT()) and ANCESTORS(), didn't work. Appreciate any help.

Shaine Greenwood

Hello Meenakshi,

You'll want to use FIND with PARENT, for example:

=FIND("Word", PARENT())

More info on FIND is available in the help center: https://help.smartsheet.com/function/find