Parent/Child row formula

I have questions

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.

Paul Newcome

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".

I have questions

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.

Paul Newcome

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.

lisa.bolger27646

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!

Paul Newcome

@lisa.bolger27646 You would use something like this:

=INDEX(CHILDREN(), 1)

lisa.bolger27646

Hi Paul!

Thank you for this!

I have a little more in this request.

Smartsheet Screenshot.jpg

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

@lisa.bolger27646 In that case you would use

=MIN(CHILDREN())

=MAX(CHILDREN())

lisa.bolger27646

@Paul Newcome this is PERFECT thank you! I love the community!

Paul Newcome

Happy to help. 👍️