Formula on Project Plan
Hi,
I have five stages on a project plan, parent row
s, with numerous child tasks underneath. I want to have a formula that marks child tasks based on this formula: =IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS"))
The parent rows also have this formula: =IF([% Complete]@row = "1", "STAGE COMPLETE", IF([% Complete]@row = "0", "STAGE NOT STARTED", "STAGE IN PROCESS")), to pull the stage progress.
Is there a way I combine these two formulas into one so I can make the column a formula versus having to drag and drop the formula for each parent and child row?
Best Answer
-
Update: I resolved this....
=IF([Stage Level]@row = 1, IF([% Complete]@row = "1", "STAGE COMPLETE", IF([% Complete]@row = "0", "STAGE NOT STARTED", "STAGE IN PROCESS")), IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")))
Answers
-
Update: I resolved this....
=IF([Stage Level]@row = 1, IF([% Complete]@row = "1", "STAGE COMPLETE", IF([% Complete]@row = "0", "STAGE NOT STARTED", "STAGE IN PROCESS")), IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!