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; } } }

How to pull the title from a hierarchy at ancestor level 0

MazU

Hi All,

I just want to pull the title 'BSR Tracker' in column 33
Please note there's another Blue bar in the same tracker i.e. two levels at ancestor = 0

so i just want to pull that title in.

currently the formula im using but doesn't seem to be working is:

=IF(COUNT(ANCESTORS([Site Name]@row)) = 0, "", IF(COUNT(ANCESTORS([Site Name]@row)) = 1, PARENT([Site Name]@row), SUBSTITUTE(JOIN(ANCESTORS([Site Name]@row)), PARENT([Site Name]@row), "")))

appreciate any assistance

@Paul Newcome Hi Paul hope you are well, just tagging you in this if you can assist as you always have
apprecaite your response

Find more posts tagged with

Formulas

Accepted answers

MazU

I have managed to find the formula

=IF(COUNT(ANCESTORS([Site Name]@row)) = 0, [Site Name]@row, INDEX(ANCESTORS([Site Name]@row), 1))

All comments

Andrée Starå

https://community.smartsheet.com/discussion/146728/how-to-pull-the-title-from-a-hierarchy-at-ancestor-level-0

Hi,

I hope you're well and safe!

Do you want to pull that name to every cell in Column33

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏

MazU

@Andrée Starå I would prefer it against every cell that has ancestor = 3 or whatever is easiest.

MazU

I have managed to find the formula

=IF(COUNT(ANCESTORS([Site Name]@row)) = 0, [Site Name]@row, INDEX(ANCESTORS([Site Name]@row), 1))

Paul Newcome

@MazU Glad you were able to get it sorted.

Andrée Starå

Excellent! Nicely done!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.