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.
