Create app script
Create app script

Update:
- auto change color onEdit 'status' column
- auto insert current date after typing report by someone
- can specify the status change column by your own
- can set the status color in difference priority
- can specify the status and color by your own
- can specify the trigger on which column and put current date to
another column

keithbox/Google-Spreadsheet-Update-Log