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
Best Answer
-
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.
Answers
-
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.
-
Nice one Thank you :)
-
Nice one Thank you :)
-
Glad I could help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 296 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!