Forumla to checkbox if Parent Row

Lisa B 2022

Hi All,

I have a grid which will be used as a timeline function for market planning.

I want to only see the parent rows on the timeline so I have tried to set up a formula to checkbox if parent row and filter the timeline that way.

I've tried =IF(COUNT(PARENT(Task@row)) > 0, 1) that formula only checks chlid rows.

I've tried =IF(COUNT(CHILDREN(Task@row)) > 0, 1) that formula only checks a parent row which has child rows.

Can anyone help with this?

Find more posts tagged with

Formulas

parent row

Timeline View

Accepted answers

Protonsponge

Hello @Lisa B 2022,

One option that might help you could be to you set up a levels column to COUNT the ANCESTORS under each row.

You could then have a IF statement to check boxes IF the level@row equals "0" (or the level you would like checked.)

I have a made a quick demo below.

Level Column

=COUNT(ANCESTORS())

Parent Row Column

=IF(Level@row = 0, 1, 0)

I hope that is helpful to you in someway,

Protonsponge

All comments

Protonsponge

Hello @Lisa B 2022,

One option that might help you could be to you set up a levels column to COUNT the ANCESTORS under each row.

You could then have a IF statement to check boxes IF the level@row equals "0" (or the level you would like checked.)

I have a made a quick demo below.

Level Column

=COUNT(ANCESTORS())

Parent Row Column

=IF(Level@row = 0, 1, 0)

I hope that is helpful to you in someway,

Protonsponge

Lisa B 2022

https://community.smartsheet.com/discussion/comment/451430#Comment_451430

@Protonsponge it worked perfectly, thank you so much!!!

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.