Revit Schedule Boolean Yes/No

Shared parameters are great for adding information to families that Revit simply does not contain. Consider a window manufacturer or supplier that either has or does not have items in stock. How does one schedule items that are available, and what if one wants to schedule items that are not available?

I created a shared parameter called availability under the grouping of Product Information. This allows me to use the parameter across a wide range of categories (Doors, Windows, Furniture, etc.).  As always, please manage your shared parameters carefully so that no duplicates come into being:

Next I insert the shared parameter into the applicable family as a type parameter.

Then set the values for the shared type parameter accordingly.

When this family is loaded into the project, the parameter automatically becomes available for scheduling.

As can be seen the cells where the Yes/No parameter is “not checked” displays as empty instead of displaying “No”

Scheduling items that are available is easy as the logical statement holds: “Is equal to yes”. In the Filter properties of the Schedule, create this logical statement as shown below:

None of the blank fields are shown:

However the inverse does not compute as the field is left blank.

Resulting in an empty schedule:

Instead use one of the following logical conditions:

“Does not equal yes“

“Is less than no”

Both of these statements return the desired result:

It is possible to place a conditional format on the filed containing “Yes”.

Resulting in

However, there is no way to place conditional formatting on “No”.


Resulting in:

If you would like to be able to add conditional formatting to a “No” value on a Yes/No parameter in a Revit schedule in the future, please vote for the idea here:

Alternatively, as a workaround, a dummy parameter can be used to populate a text parameter explicitly with either “Yes” or “No”. In this case, as the parameter will always have a value attached, the schedule would be able to conditionally format No. the topic is covered here:

Was this helpful?

Thanks for your feedback!

About the Author


About the Author