Forums >> Revit Building >> Technical Support >> can you hide zeroes in schedules?

jlights

active

Joined: Tue, Dec 18, 2007
146 Posts

I've been asked to see if there is a way to make Revit schedules show a blank when the value is zero for various parameters. (It's early in the project and they only want to show what they know at the moment). I've not been able to find a way to do this in field formatting, and conditional formatting doesn't do it either. Does anyone know if it is even possible to do this?

thanks.

-----------------------------------

jlights

This user is offline

View Website

TKennedy

active

Joined: Wed, Oct 7, 2009
654 Posts

As far as I've been able to figure out, no. If it's not a text parameter, it has to display a value.

This user is offline

jlights

active

Joined: Tue, Dec 18, 2007
146 Posts

Thanks. That's what I thought!

-----------------------------------

jlights

This user is offline

View Website

TKennedy

active

Joined: Wed, Oct 7, 2009
654 Posts

We don't really have a way to fix the issue, but we are able to get around it. Basically, those schedules never get issued until we are ready to fill them out. We have other schedules that show a small amount of information (Item #, quantity, description, remarks) and those are what we send early in the project. The utility schedules (the ones with rows of 0's) still exist in the project and could theoretically be seen by the architects, but they aren't on any sheets.

ETA:

It's not a fix, and only somewhat related to your question, but something else I've been doing is setting up conditional formatting to make a cell with a 0 red. That makes it much easier to work with when I start filling out the schedule, it's very obvious which cells I still need to look at.

This user is offline

jlights

active

Joined: Tue, Dec 18, 2007
146 Posts

We did end up hiding the columns without data when we had to send out the first round of drawings as you mentioned. We're just starting to use Revit schedules so some of these issues are coming up for the first time. Keeping a separate set of "utility" schedules and another for sheets may be a good idea. Now if only Revit would allow you to make dependent schedules! We have several schedules that have to be broken up into 2-3 parts, so there is one complete schedule and then A, B, and sometimes C versions. It's a real pain when you need to add or change a parameter and you have to do it in the main sched and then in the part sched that goes on the sheet.

I like the colored cells idea, which I will bring to the designers to see if they would  find that helpful. Thanks again for your ideas.

-----------------------------------

jlights

This user is offline

View Website

TKennedy

active

Joined: Wed, Oct 7, 2009
654 Posts

Schedules are going to be a PITA until you figure out what you need to show. Once you do, make sure you get all those schedules into your template. Another thing to keep in mind is that schedules can be transferred between projects using the 'Insert views from file' tool, so don't try to recreate schedules in any current project, get them set up in one then transfer them to the others. That will work for your template as well.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Just a tip for everyone....

Schedules in Revit are powerful tools if you learn to use them.  Don't be afraid to create multiple schedules of the same elements filtered and setup in ways that will help you with your work.  We have sheet schedules that are formatted and setup correctly for the sheet.  Then we have other working schedules (just copy your sheet schedule and rename) that we manipulate as we need. 

For instance, maybe all of your offices will have carpet on the floor.  Filter or sort the room finish schedule appropriately and don't show all instances so that all of the offices are now in one line and fill in the carpet data.  DONE for all!

Or maybe in a hotel project, all guestrooms shall have the same entry door number of 1.  Filter and sort the door schedule for guestrooms and change the door number to 1.  Done for the schedule and all the plans at the same time.

This user is offline

Structural Beam Schedules

3

Hide Isolate

2

multiple schedules

2

Hiding Rows in Schedules

2

Schedules for Information In Schedules HAHA

1