Thanks a lot for all the suggestions! Here is what I think I should conclude with:
I think it worked, but all the formulas I added to the cells are gone.
- If I enter "open" in cell ( K7 ) the word "pending" will appear in cell ( M7 ).
- If I enter "closed" in cell ( K7 ) the date of today will appear in cell ( M7 ).
- If nothing entered in cell ( K7 ) nothing will appear in cell (M7 )
- And so on to the rest of the cells .
- This is the formula I was using :
It worked for me. Hope, it will work for rest of you also!