I am trying a build a master list of documents list on our portal. The aim here is to list all doc names, IDs, last modified date, modified by, doc status( approved,pending) and version number.
I have created a view that shows all this information but when i try to export it to spreadsheet it does not bring over the version number.
Other option i tried is by running a report from designer but the data requries a lot of clean up and ofcourse it required desinger which not everyone has except me.
I was wondering if there is a way to automatically dump all this data into a list and just maintain that?
Thanks in advance!