nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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.

Find more posts tagged with

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…
COUNTIFS - count the number of dates that fall within one month
Hi Community! Hoping you can assist. Can you tell me what is wrong with this formula for counting how many publications that fall within one month? =COUNTIFS( [Publication Date]:[Publication Date], >=EOMONTH(TODAY(), -1) + 1, [Publication Date]:[Publication Date], <=EOMONTH(TODAY(), 0) ) The date in the Publication Date…
Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…