I have a spreadsheet where I track the status of items that I process i.e. Step 1, Step 2, Step 3, etc. I want to be able to log the time when the status changes. If I am on step one the date is logged and the formula is static. When I change the status to step two a static date will be entered in step two cell and the date in step one will not be affected.
Solved by G. W. in 18 mins