Welcome!

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

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.

Formulas

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

Formula returning "2" suddenly, other cells, same formula not returning the "2"
Please see attached, formula has worked for a long time an typically pulls the data from another sheet as intended. I looked today and suddenly I have a "2" in a lot of the empty fields, and cannot figure out why. The formula I am using: =IFERROR(IFERROR(INDEX({PERFECTION YARD CHECK RO #}, MATCH(VIN@row , {PERFECTION YARD…
Formulas reading from ROW above.
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…