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 PirulliDid you try my posted solution above?

Fabrizio Pirulli · 09/24/20

@Fabrizio Pirulli<\/a> Did you try my posted solution above?<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Fabrizio Pirulli\",\"userID\":126565}}},{\"insert\":\" Did you try my posted solution above?\\n\"}]","format":"rich","dateInserted":"2020-09-24T20:17:47+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/263691#Comment_263691","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/263691#Comment_263691

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

Paul Newcome · 09/25/20

@Fabrizio PirulliAre 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 Newcomei'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 Newcomeany 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 bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!