Attached is an example file showing how to create worksheets that list Revision and Issue data.
The data for revisions and issues, is not stored like other data attached to objects. For each revision or issue, there is a separate record field. So to list all revisions or issues, you have to create a worksheet will multiple database rows, each set to the needed record fields.
In the example file, there are worksheets showing the formulas needed to pull this information. For each issue/revision and new database row is needed. As for the criteria, we suggest limiting the worksheet to a sheet layer and the sheet border object as shown in the example file. For reference, here are the basic formulas needed:
=('Issue Data'.'Number-1')
=('Issue Data'.'Date-1')
=('Issue Data'.'Note-1')
=('Issue Data'.'Approved-1')
=('Revision Data'.'Date-1')
=('Revision Data'.'Description-1')
=('Revision Data'.'Zone-1')
=('Revision Data'.'Approved-1')
To show subsequent issues or revisions, you need to duplicate the database row below the previous row and change the number at the end of the formula. So for 5 issues, you will have 5 database rows, each with the same formulas above, except the number at the end will change to 2, then 3 and so on.
Note, that the Revision Number is not stored in the record. You will need to manually enter the number for each row. The =1, =2, =3… formulas were used to create the numbers in the example file.
The initial setup of these worksheet will take some time, however after they are created they can be placed into any project to quickly create an Issue or Revision worksheet. Both Issues and Revisions have a limit of 49. However, in most cases you will only need to setup you worksheets for 10 or so issues/revisions. If you have a project with more than 10 issues/revisions, simply add those lines to the worksheet as needed.
Edited by JimW
- 1
Report Article
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.