Project Phases of Development

Jennifer Kaupke · 01/02/20

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 · 01/03/20

Try something like this...

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

Paul Newcome · 01/03/20

Try something like this...

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

Fabrizio Pirulli · 09/23/20

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 · 09/24/20

@Fabrizio Pirulli Did you try my posted solution above?

Fabrizio Pirulli · 09/24/20

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 · 09/25/20

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

Fabrizio Pirulli · 09/29/20

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 · 10/04/20

Hi @Paul Newcome any suggestions?

Paul Newcome · 10/05/20

Is it the same exact formula on both lines?

Fabrizio Pirulli · 10/05/20

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

Andrée Starå · 10/06/20

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 · 10/06/20

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å · 10/06/20

@Fabrizio Pirulli

I can't see a formula in the screenshot?

Fabrizio Pirulli · 10/06/20

@Andrée Starå

This is the formula:

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

Thanks

Paul Newcome · 10/06/20

Try referencing the Primary Column in the first CHILDREN function.

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

Fabrizio Pirulli · 10/07/20

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

Thank you very much for your support

Explore. Ask. Answer.

Project Phases of Development

Best Answer

Answers