Parent/Child row formula
What would be the formula to use for when you want to update the parent row with child row data? For example, if a subtask under the parent row is marked as 'In Progress,' I'd like for the parent row to be reflected as 'In Progress.' Thank you.
Answers
-
There are a number of options. What are the different statuses available and which order would they be prioritized in? For example: If there is even 1 "Late" it will override everything else and output "Late".
-
Thanks for your response. There is no real priority ranking. The statuses are either Not Started, Complete, and In Progress. For example, if anyone of the subtask are marked as In Progress, I would like the parent row to be reflected as In progress.
-
What I meant by "priority" is more along the lines of this...
If there is one "In Progress" then the parent should be "In Progress" regardless of the other child rows. If ALL are marked "Complete" then the parent would be "Complete", but if all but one is "Complete" and that one is "Not started" then would the parent row would be "In Progress", or would you want "Not Started" or "Complete".
Basically we need to establish the hierarchy and logic for each possible scenario.
-
Hello Smartsheet Community! I have this same question. I simply want the parent row to inherit the data in child the row immediately beneath it. With the exception of the Primary column, I'd like each of the columns to inherit the data in the row just beneath it. Is this possible?
Thank you in advance! I love the community!
-
@lisa.bolger27646 You would use something like this:
=INDEX(CHILDREN(), 1)
-
Hi Paul!
Thank you for this!
I have a little more in this request.
Is there a way for the Start Date and Finish Date to automatically populate under each blue heading? We want the Start Date to be the earliest date and the Finish Date to be the latest date. See screenshot.
I REALLY appreciate your help!
-
-
@Paul Newcome this is PERFECT thank you! I love the community!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!