Project Phases of Development

Jennifer Kaupke

Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. For example (see image), if "Project Planning," "Drafting," and "Developing" are all at 100% complete then the project would be in "Post Production." Once "Post-Production" is complete, the project would be in "Final Review," and so on. I would be happy to add a column for a checkbox or whatever to make this happen. Thank you in advance for your help!!

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)

Fabrizio Pirulli

Hello everyone,

i'm getting in the same situation as Jennifer.

I need to get the last completed parent task, in order to know in which phase the project is.

In the example, i'd like to fill the yellow cell with the value of the green cell "Technical analysis and solution" because is the parent task (or phase) where the project is actually running (all the previous tasks are 100%).

Hope you could help me

Paul Newcome

@Fabrizio Pirulli Did you try my posted solution above?

Fabrizio Pirulli

https://community.smartsheet.com/discussion/comment/263691#Comment_263691

Hi @Paul Newcome yes, but isn't working at all. Can you help me?

Paul Newcome

@Fabrizio Pirulli Are you getting an error or an inaccurate result? What exactly is happening and what exactly should be happening?

Fabrizio Pirulli

Hi @Paul Newcome i'm getting this (two different errors on two lines):

using this formula: =INDEX(CHILDREN(); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)

Thanks

Fabrizio Pirulli

Hi @Paul Newcome any suggestions?

Paul Newcome

Is it the same exact formula on both lines?

Fabrizio Pirulli

Yes! I really can't reach the reason why I obtain different results

Andrée Starå

Hi @Fabrizio Pirulli

Can you paste the exact formula you're using?

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Fabrizio Pirulli

https://community.smartsheet.com/discussion/comment/264108#Comment_264108

Hi @Andrée Starå i've already posted the exact formula above.

Here a new screenshot:

Andrée Starå

@Fabrizio Pirulli

I can't see a formula in the screenshot?

Fabrizio Pirulli

@Andrée Starå

This is the formula:

=INDEX(CHILDREN(); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)

Thanks

Paul Newcome

Try referencing the Primary Column in the first CHILDREN function.

=INDEX(CHILDREN(Attivita@row); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)

Fabrizio Pirulli

Hi @Paul Newcome thanks, it's working!!!

Thank you very much for your support