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!!
Best Answer
-
Try something like this...
=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Try something like this...
=INDEX(CHILDREN(), COUNTIFS(CHILDREN([% Complete]@row), @cell = 1) + 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes! I really can't reach the reason why I obtain different results
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
I can't see a formula in the screenshot?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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(Attivita@row); COUNTIFS(CHILDREN([% di completamento]@row); @cell = 1) + 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives