How to auto compute the task Status based on the task and predecessors % Completion status


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!