For columns I would like to be able to toggle on/off an accountability feature such that:
- when a cell change is made the user is prompted to log a reason for the change
- the reason would populate into an adjacent cell, so that it's easily visible in reports/dashboards
- the person who made the change would be logged into a cell
- the date/time the change was made would be logged into a cell
It's possible that this is a seperate sheet. For example, if the activity log was a companion sheet that is created when a new sheet is made. In that way, you could have a formula doing a lookup to the activity log, which means with a lookup formula every cell would have at least #3 and #4 from above visible for reports/dashboards.
But the main idea here is that there are some cells changes that having a reason for the change is important.
