Appendix or Reference Sheet/Document
I would like to create an appendix or reference document that lists all of the sheets currently in use on our account.
The idea is then to have the all the information about that sheet per row containing Sheet name, hyper link to the sheet, sheet owner, editors, viewers, created date and if possible the last time it was saved or updated.
I can go about setting this up by myself and can do most of these columns but I wondered if any one had any tips on doing this before I start from scratch. In particular how would i get it to show the last saved date and add any changes in the rights columns.