I watched the youtube video labeled, "Automatically Add Date/Time to a Cell When You Enter || Record Date and Time when Value is Changed". I want to do this but I could not figure out how to change it so that the date changes in another column, besides 'B'. I attached an example of what I'm talking about. How can I change the date in column G of the "Main" Sheet as well as column F of the "Caterpillar" sheet? Also, is there a way to move the entire row to the Closed sheet if I select "Closed" in the Current status column? Or to reverse it and send it back to the original spot if I accidentally chose "Closed"?
12.9 KB Views: 4