Project Phases of Development
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!!
0
Best Answer
-
Paul Newcome ✭✭✭✭✭
Try something like this...
=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)
thinkspi.com
5
Answers
Try something like this...
=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)
thinkspi.com
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
@Fabrizio Pirulli Did you try my posted solution above?
thinkspi.com
Hi @Paul Newcome yes, but isn't working at all. Can you help me?
@Fabrizio Pirulli Are you getting an error or an inaccurate result? What exactly is happening and what exactly should be happening?
thinkspi.com
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
Hi @Paul Newcome any suggestions?
Is it the same exact formula on both lines?
thinkspi.com
Yes! I really can't reach the reason why I obtain different results
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!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Hi @Andrée Starå i've already posted the exact formula above.
Here a new screenshot:
@Fabrizio Pirulli
I can't see a formula in the screenshot?
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
@Andrée Starå
This is the formula:
=INDEX(CHILDREN(); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)
Thanks
Try referencing the Primary Column in the first CHILDREN function.
=INDEX(CHILDREN([email protected]); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)
thinkspi.com
Hi @Paul Newcome thanks, it's working!!!
Thank you very much for your support