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

Asyraf

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.

Asyraf

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.