Item 1
If column A hv value then column C "Pending"
If column A and B hv value then column C "Completed"
If A and B no value then C is blank.

Item 2
If copy and paste in column A then column B will automatically timestamp.

Thanks