How to auto compute the task Status based on the task and predecessors % Completion status
![Asyraf](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
The snapshot is my sample Project Plan.
From this data table, appreciate if the expert can help me to derive the Status column formula based on the following remark:
1. Status column with the status Not Started is the % Complete equal to 0%.
2. Status column with Complete is when % Complete archive 100%.
3. Status column with Ready to start is when all Predecessors % Complete achieve 100% in example task in row 12.
4. Status column with the status In Progress is when % Complete in between above 0% and less than 100%.
I would appreciate, if anyone has developed or encountered any suitable solution for the above.
Thank you.
Answers
-
to conclude this question, I have found the solution for the above as per this link https://community.smartsheet.com/discussion/114937/status-with-predecessor#latest
Credit to @jmyzk_cloudsmart_jp for the support.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!