Formula to get the last child row and apply conditional formatting

I have a sheet conditional formatting has been applied so that Ancestor = 0 is one color, Ancestor = 1 is another. Ideally, I'd like to apply conditional formatting so that all rows with Ancestor = 2 are conditionally formatted to the automatic format style except for the last row which will be a different color.

I'm still relatively new to Smartsheet / Smartsheet formulas but I feel like there has to be a way to indicate if the row is the last row with an Ancestor count = 2.

It feels like a simple ask but I can't seem to find the right post in the community / online to help me solve the issue.

Find more posts tagged with

#formula

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @hparx

This set-up will give you the last child row.

[Last Child] =AND(COUNT(CHILDREN()) = 0, MAX(COLLECT([Row ID]:[Row ID], Parent:Parent, Parent@row )) = [Row ID]@row )
[Row ID]
[ANC] =COUNT(ANCESTORS())
[Primary Column]
[Parent] =PARENT([Primary Column]@row )

https://app.smartsheet.com/b/publish?EQBCT=003b43f2ca0f4018a381d8f8b1b52ddd

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.