Organize schedule

[linkboy]

Below is a door schedule, for door #1 the "yes/no" parameters being converted  into numbers. How can I get rid of the space btw 1 & 3 in the case no option 2? Thanks,

[ToanDN · Accepted solution]

Use Combine parameter if they are not calculated value parameters.  Otherwise, create a calculated value parameter that covers all conditions (it will be a massive line of code).

Example (1 and 3) for you to expand the formula to other conditions:

0, 1, 2, 3, 1 and 2, 1 and 3, 2 and 3, 1 and 2 and 3.

[linkboy]

Converted numbers are calculated parameters, not able to feed into combine parameters.

[barthbradley]

---

@linkboy wrote:

How can I get rid of the space btw 1 & 3 in the case no option 2? 

---

Like this? 

Hide.

[linkboy]

Hide works for one row, next door might need option 2.

[ToanDN]

---

@linkboy wrote:

Hide works for one row, next door might need option 2.

---

Can you work out the formula that I started?  It is long but not that complicated, mainly copy and paste code.  Do it in Notepad then copy paste to Revit.

[barthbradley]

Oh, I get what you want.  Well, if you have the stamina, you can write a formula with 81 nested if statements, then you could have all the possible permutations together in one cell - separated by commas.  

Or you could forget the commas and just separate the values with a border line.  

Or you could just drink.  Isn't it beer-thirty yet? 😉 

[linkboy]

yes, I had one using conditional formula. But your (and ) is simple. Let me try.

[barthbradley]

Are you seriously considering trying to tackle this:

=if(and([ADA Entry (No. 1)], [not(Card Reader (No. 2)]), if([Panic Hardware (No. 3)], "1,3", if(…so on and so forth 80 more times to catch every possible premutation…,””). 

[ToanDN]

Yeah 8 conditions to cover all you ever need.  Simple enough.  Don't let others dumb you down by persuading you need to add more.

[barthbradley · Accepted solution]

YYY

YYN

YNN

YNY

NNN

NNY

NYY

NYN

Guess you're right. I was thinking permutations like Rubik's Cube.   Actually, it's combinations- just eight of them.  That's doable.  

[linkboy]

thanks for the list.