How to write a condition for Google Sheets?

Question

Google Sheets

Dear experts, please tell me if it is possible to implement such an idea:
A table with several columns
In column "A" data validation is configured:
"Not started"
"Completed"
"In progress"
In column "L":
Data validation is configured:
0%
25%
50 %
75%
100%
Conditional formatting is configured:
Own formula: "=$L4=100%" - saying that if the value in the cell is 100%, then the color of the entire selected row is painted in a certain color.
But the essence of the problem is as follows:
Is it possible to finish the formula to such conditions:
If the column "L" in the cell has a value of 100%, then in the column "A" in this line, the value "Completed" is automatically substituted and the line of the selected range is painted in the desired color.

Answer 1

In column A, instead of choosing, put the formula: =IF(L4=0, "Not started", IF(L4=100%, "Completed", "In progress")), conditional formatting is configured separately.

Answer 2

Is it possible to add the formula

Yes, it's possible.