Auto fill

hello

I hope this message finds you well. I am currently working on a project where I have a sheet containing columns for tasks, locations, and tasks under different child categories. I am looking for assistance in creating a formula to automatically fill up the location column in the main row category with the corresponding location information.

If anyone has experience with a formula that achieves this or can provide guidance, I would greatly appreciate your help.

Thank you in advance for your support.

Regards

Alister

Find more posts tagged with

Accepted answers

KPH

Is this what you are looking for? Or close?

Here I have put the parent text from the task column into the location column.

This is achieved using

=PARENT(Task@row)

Which if applied to the whole column would look like this:

You can add some IF functions to only do this for certain rows. For example, to make this display only for rows with 4 ancestors, you could do this.

=IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), "")

And to pull across the row with 3 ancestors, you could nest another IF, like this:

=IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), IF(COUNT(ANCESTORS(Task@row)) = 3, Task@row, ""))

I hope that is what you need.

All comments

KPH

Is this what you are looking for? Or close?

Here I have put the parent text from the task column into the location column.

This is achieved using

=PARENT(Task@row)

Which if applied to the whole column would look like this:

You can add some IF functions to only do this for certain rows. For example, to make this display only for rows with 4 ancestors, you could do this.

=IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), "")

And to pull across the row with 3 ancestors, you could nest another IF, like this:

=IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), IF(COUNT(ANCESTORS(Task@row)) = 3, Task@row, ""))

I hope that is what you need.

Alister

Nice one Thank you :)

Alister

https://community.smartsheet.com/discussion/comment/416133#Comment_416133

Nice one Thank you :)

KPH

Glad I could help.

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.