Revision schedule inserting blank rows

[rosader]

My revision schedule (built into the titleblock) is giving me some issues. I noticed all of the revisions will show the current rev # in the titleblock as expected but in the schedule, some revisions will show up as a blank row.

What I have observed while trying to figure it out is that it most likely has something to do with the revision sequence number. As long as the revision has a single digit sequence number, it displays in the schedule just fine. When the sequence number is 10 or above, it inserts a blank row into the schedule.

Why would double digit revision sequence cause this issue?

BTW the revision sequence is a hidden field

[barthbradley]

Why don't you edit the Titleblock and resize the column in the Revision Schedule?  

...at least that's how I'm reading your issue. The text is wrapping and you don't want it to wrap.    

[ToanDN]

Can you show a screenshot of the revision schedule settings in the TB family and how it appears on sheet in a project?

[rosader]

That was my first thought as well. The revision sequence number is a hidden field but I did try unhiding and resizing the column to see if that fixed it but it didn't.

[rosader]

[rosader]

It's possible it has nothing to do with single vs double digit but in looking at everything, my revision 4 and 5 are sequence number 18 and 21.

I tried removing sequence 18 and 21 and replaced w/ sequence 7 and 8 and then it displayed revision 4 and 5 just fine

[ToanDN · Accepted solution]

Is the No. column referencing Revision Number or Sequence?  They are different things and I think you should sort the schedule by Sequence, not Number.  

[M-Alam]

un-check the box for Blank row before data under appearances.

[rosader · Accepted solution]

OK so I just noticed the NO. field has a formula. 

if(Revision Sequence < 11, Revision Number, "") 

This titleblock template was not created by me so I didn't know how everything was setup but I this is probably the culprit 

[ToanDN]

---

@rosader wrote:

OK so I just noticed the NO. field has a formula. 

if(Revision Sequence < 11, Revision Number, "") 

This titleblock template was not created by me so I didn't know how everything was setup but I this is probably the culprit 

---

Yes it certainly is.  

[rosader]

Thank you all for leading me down the right path. It's been frustrating the daylights out of me all day and it this whole time it was a simple formula messing it up.

[barthbradley]

What was the formula?  

[rosader]

if(Revision Sequence < 11, Revision Number, "")

It was basically limiting number of sequences to 11. I just set it to a much higher number and all my revisions appeared in the schedule.

[ToanDN]

---

@rosader wrote:

if(Revision Sequence < 11, Revision Number, "")

It was basically limiting number of sequences to 11. I just set it to a much higher number and all my revisions appeared in the schedule.

---

I don't understand the need for this formula.  You can limit the number of revisions shown in the schedule easily, and shouldn't the newest ones be showing instead of hiding?