# Thread: Yes / No Formula Controlling (2) parameters

1. ## Yes / No Formula Controlling (2) parameters

Hello

I'm creating a family right now and I'm wanting to use a formula to control 2 parameters with it.

Here's the specific scenario: I have 3 grades of finish for a countertop family I am creating; economy, custom, and premium. I have yes / no parameters assigned to them all and what I am hoping to accomplish is to turn off the other two parameters when one box is checked. So, if I were to turn (or check) on the permium grade finish box, economy and custom grades would turn off.

I can make it work with just one or the other parameters. An example of this is I can turn on premium grade and get economy grade to turn off. I can't however make economy and custom turn off.

So far, the boolean formula is simply "not (Economy Grade)" when I want premium to be displayed. Every time I try adding in "Custom Grade" I get owned by Revit who thinks it's too good for users with above average intellect. Any super geniuses out there who have a work-around or know how to achieve this desired result?

2. ## Re: Yes / No Formula Controlling (2) parameters

SImple...

but I dont think this will help you much since you wont beable to have all 3 parameters have formulas...

edit: Sorry - got it wrong - should be

3. ## Re: Yes / No Formula Controlling (2) parameters

The only way to make all three "fool proof" is to have them all reference a fourth parameter. IE one is a selector of "1, 2, 3" and the other parameters are equal to "2" or "3" or "1." You cant have all three be automated off the other two, or theres a circular chain.

4. ## Re: Yes / No Formula Controlling (2) parameters

Originally Posted by Alex Page
If you try to do a similar formula to turn off the other two parameters, that will trigger the "circular chain of references" error.

Two possible solutions are these:

Solution A: by types
Solution B: by integers

See illustration for a description of each solution.

5. ## Re: Yes / No Formula Controlling (2) parameters

We use Alfredo's method with integers. However, if you are certain check boxes are the way you want to go you will need 5 parameters, three you can 'check' only one of which actually drives the visibility directly. The other two drive a formula in the corresponding visibility Yes/No parameter. You can use Alex's formula to do this. It's cumbersome but the simplest way to do what you want if Yes/No parameters are a must for whatever reason.

6. ## Re: Yes / No Formula Controlling (2) parameters

The thing is that if you use other parameters to check, you still have to ensure you turn off and on the correct parameters, so it doesnt really save you any clicks.

I generally dont bother with this approach anymore, I just turn off and on as required.....not a pain once you know thats what you have to do

7. ## Re: Yes / No Formula Controlling (2) parameters

With 3 parameters, you only manage the 2 Yes/No boxes - but I agree...it's too much trouble. Ideally, we could group Yes/No parameters into a Radio Button group where one and only one can ever be Yes.

8. ## Re: Yes / No Formula Controlling (2) parameters

Thanks everyone for the help! After a little review it did seem to be a bit cumbersome. I really like the integer approach. An even better approach I might try first is to create a schedule a set of values / project parameters within my project that the family will reference. I don't know how this will control the visibility of the object, but these are the learning curves we go through I guess.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•