Questions with IF formula

[max.a.hollander]

Im having an issue with an if formula.

In an Fire smoke damper (it is a duct accessory) Family, i have the motor set so it can be on either side of the unit.  i have the motor set to a yes/ no parameter with a not(left side motor) formula to link the to sides of the motor.  I want to write a if formula so i can have my fsd schedule have a colunm that indicates wheather it is right or left sided for orderin purposes.   but i cannot set up the formula so that when it is marked on the left side a text would say left 

[CoreyDaun · Accepted solution]

You will have to create a Shared Parameter (Text), add it to your Family, and assign the formula:

if(right side motor, "RIGHT", "LEFT")

[max.a.hollander]

Corey you are the master thank you! i was forgeting the "XXX" quotations

[CoreyDaun]

Glad I could be of assistance!

[max.a.hollander]

now i have to add an extension that if the fsd is larger then 36" with i want it to say both because the FSD would need two motors. I am novice with formulas

[CoreyDaun]

It can be set up so that that the "left side motor" is checked under certain size conditions, but the trouble you're going to run into is if the user unchecks the "right side motor" parameter when the unit is larger than 36" - there's no way to have it automatically check the box under certain conditions and then allow the user to control it under other conditions.

My recommendation is to create another Yes/No parameter to correctly control the visibility of the "right side motor" elements in the family; call it something that won't confuse another user, like "rsmvis" (so he doesn't see two controls for the right motor) and group it under Graphics or under some other group separate from the other two parameters. Set the formula for this parameter to:

= or(right side motor, fsdlength > 36")

This means that if either the user checks the box for 'right side motor' OR the unit size s greater than 36", this parameter will be "YES".

Now, revise the formula for your left size motor to:

= or(not(rsmvis), fsdlength > 36")

This means that if either the 'rsmvis' parameter is NOT "YES" OR if you length is greater than 36", the 'left side motor parameter' will be "YES".

Finally, change your text parameter to:

= if(fsdlength > 36", "BOTH", if(rsmvis, "RIGHT", "LEFT"))

This means that it first checks the size of the unit and if it's not greater than 36", it follows through and checks whether the right or left motor size is selected.

That should do it.