This question already has an answer here:
In Google Spreadsheets, is there a simpler way to put the edited date of a cell into another cell?
I've set a data validation list:
to F column. If the value of F column is changed to ACTIVE, the value of corresponding G column cell should be that date.