Schedule calculated value OR conditional statement

[j0258169]

I have a sheet list with a bunch of yes/no parameters. I need to use these yes/no parameters in a calculated value. Specifically, I'd like to run a calculation that tells me if any of the yes/no parameters are 'yes'.

The default value for these yes/no parameters is that greyed out not quite checked, not quite unchecked state. Any calculation that I run on a yes/no parameter that is not specifically checked or unchecked does not function, it just seems to stop running when it hits this ambiguous value.

Is there any way to get Revit to treat these as unchecked?

[SteveKStafford · Accepted solution]

Gray/disabled means undecided or maybe. You need to assign each to one or the other.

[barthbradley · Accepted solution]

Grey = NULL. Not Yes. Not No. Can't be evaluated. Default checkmark means nothing.  You have to activate it by actually checking or unchecking it.