Forums >> Revit Building >> Technical Support >> Calculated field on sheet to state whether "numeric" or "Alphabetic" no. used

sgraysonhks

active

Joined: Wed, Jul 22, 2009
2 Posts
No Rating

REVIT 2011: 

We're trying to create a drawing sheet that automatically indicates whether the revision number for the sheet is "Alphabetic" or "Numeric" so that we can indicate whether a sheet is "Preliminary" (numeric numbering) or "Construction" (alphabetic numbering). We can do this with a simple tick box to hide or show text that reads "Preliminary" or "Construction" but want this to be automatic to avoid people forgetting to update the sheet.

I had hoped it would be possible to do this by creating a Revision Schedule on the sheet that used a Calculated Value with an IF statement to provide a value of "Preliminary" if the sheet number was between 0-99 or "Construction" if between A-Z (the extent of our revision sequences), but I can't work out the correct code to get something like:

if(Revision Number <99, "Preliminary"

if(revision Number <Z, "Construction"

Any ideas?

Cheers.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Why don't you use a drawing list to do this for you?  Just duplicate your index and add the current revision data.

This user is offline

sgraysonhks

active

Joined: Wed, Jul 22, 2009
2 Posts
No Rating

Thanks for the reply, but we want this to be a feature within the drawing sheet family so that we can load it across projects and I do not believe that you can put a sheet list into a sheet family.

I would think a sheet list would also require us to create a manual field against each revision to select whether the revision is "Preliminary" or "Construction"?

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

I thought you wanted to manage these sheets - not put data on them that forces you to look at each sheet.  When you look at the sheet, you should be able to see the revision yourself and no need for your formula.

But maybe my logic is all wrong!

This user is offline

tagging by "family name" and "family type"

1

changing the "family" and "type" names

3

Can the room schedule have a column that automatically fills in ceiling height?

1

Room Schedules: Using "Count" in Calculated Vaules....???

0

help "painting a field" ?

2