I'd like to display all previous revision numbers in my title block. This is the way my company's title block is set up and I'd like to automate it.
I was thinking the best way to do it would be to link the visibility of the revision number (which at the moment is just a text box) to the "Current Revision" of the sheet. So for [2], if "current revision" > 1, visible, else invisible; for [3], if "current revision" > 2, visible, else invisible. The problem is that I can't seem to find a way to use "current revision" of the sheet in visibility formulae in the title block family. Is there a way to do this that I'm missing, or isn't it possible?
This does seem like a bit of a caveman solution for displaying the list of revisions automatically, but I can't think of a better way to do it. Surely there must be a solution or a cleverer way to do this?
And don't tell me to change the way revision numbers are displayed - I agree, I don't think it makes sense. But it's not my firm, so my opinion isn't going to change anything 😄
Thanks in advance!
Solved! Go to Solution.
Solved by lucdoucet_msdl. Go to Solution.
@roryGTFF5 wrote:
This does seem like a bit of a caveman solution for displaying the list of revisions
Actually, I think this was the format that cavemen used:
You will need to better explain the revisioning system for us to help you. Here are a couple of questions:
Please clarify so that we can better help you,
-luc
Hi Luc,
Thanks for following up.
1. Revisions are listed by sheet and by project stage. So ground floor plan for sketch phase will have a list of revisions, when moving to design development phase these reset to 1 again.
2. Revisions are listed from left to right in increasing order. We haven't reached the last block of the revisions yet, so I'm not sure. I'd have to ask my director if that ever happened.
3. There's actually a revision schedule higher in the title block that lists the revisions in the sheet, the date of issue, who drew the revisions and the description. I've used a revision schedule to capture that information.
4. No, the 'ISSUED FOR...' changes depending on the phase (design, local authority, tender, etc.) and is changed manually. This is something I had also wanted to address based on the sheet number (eg., if the sheet number has a _T_ (for tender phase) then it checks the correct box), but it seems to be a similar issue in that the visibility for these boxes can't be tied to a parameter of the sheet, in this case the drawing number.
5. The diagonal line hatch is just a way to tick that box that looks neater than a check mark.
Thanks for taking the time to reply. Hopefully the above will provide enough clarity to get an answer.
As revision schedules do not allow column breaks, a work-around would be to create multiple 1 cell high and wide schedules for each of the "slots" in your revision bar. Each slot would then have a text calculated parameter based on the numerical revision order set up as an if statement for each numeral.
For example, to display "4" if the current revision order is more than 3 otherwise place a blank character:
IF(Revision Order > 3, "4", "")
You would then adjust the height and width to the size of the "slots" and line them up, so that they only show one line of revisions.
Hope this helps,
-luc
Thank you so much for this, you're a human genius. It worked perfectly. A bit of a work-around, of course, but it is a very specific application. I never would have thought of this, and I certainly wouldn't have had the patience to work through it!
I appreciate the help!
@roryGTFF5 wrote:Thank you so much for this, you're a human genius.
Thanks for specifying my humanity 😉
With ChatGPT on the rise (obligatory salutations to our AI machine overlords!), our days helping other users may effectively be limited.😅
-luc
Can't find what you're looking for? Ask the community or share your knowledge.