fx to auto pop TASK CATEGORY, single select drop down, based on parent row TASK NAME, primary column

I am trying to use card view reporting and sheet function sorted by TASK CATEGORY single select drop-down column. Below are 2 screen grabs, 1 is TASK NAME, primary column, children rows collapsed.

The 2nd is with children rows expanded on 1 section and a simple fx I am using to copy the TASK NAME parent cell to the TASK CATEGORY single drop-down select column.

I feel like the way I am doing it is clunky and not the most efficient way. For example, if I add a row, I have to make sure I copy the fx into a new row, or if I move a row to s different section, I have to update the fx manually. The issue is, i have 25 project sheets so doing it this way does not scale. Does anyone know a better fx to use here? I was using =PARENT([TASK NAME]@row) but this doesn't work for single select drop-down columns and therefore doesn't work for card view sorting on reports. I need an fx that is a mix of the 2 simple fx i have tried. Please help, I'm a little lost in the sauce here.

Screenshot 2024-07-31 at 10.14.39 PM.png

Screenshot 2024-07-31 at 10.15.02 PM.png

Find more posts tagged with

Manufacturing

Formulas

Card View

Accepted answers

Paul Newcome

Sorry about that. I wasn't paying attention and flipped my logic on the output… Try this:

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, [Task Name]@row, PARENT([Task Name]@row))

All comments

Paul Newcome

Try this:

=IF(COUNT(CHILDREN([Task Name]@row)) = 0, [Task Name]@row, PARENT([Task Name]@row))

Pnda

Almost, the formula is returning the cell directly to right in same row. Do i need to make a helper row to distinguish parent/child rows?

Paul Newcome

Sorry about that. I wasn't paying attention and flipped my logic on the output… Try this:

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, [Task Name]@row, PARENT([Task Name]@row))

Pnda

Works! thank you very 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.