Using Unselected/Default Yes/No Parameter in Formula

Using Unselected/Default Yes/No Parameter in Formula

thomk
Enthusiast Enthusiast
323 Views
1 Reply
Message 1 of 2

Using Unselected/Default Yes/No Parameter in Formula

thomk
Enthusiast
Enthusiast

Is there a way to include objects that are still in the unchecked state for a yes/no or any other parameter?  I've tried and as well as or and not to no avail.

 

The formulas I have tried will only work on objects that have the value set to either yes or no and they completely ignore the objects that are still in the initial state.

 

Basically, "Do Operation X to only the objects that are set to either 'no' or haven't been set yet and do something else with the objects that are explicitly set to 'yes'."

 

I am trying to not have to manually set the parameter for all new instances of the areas that I'm placing.

 

Thanks again!

0 Likes
324 Views
1 Reply
Reply (1)
Message 2 of 2

ToanDN
Consultant
Consultant

I don't think you can categorize NULL as either TRUE or FALSE just by a formula.  I usually create a schedule sort by teh Y/N field, unitemize rows, so that I can tick or clear any new NULL values with just one click.

 

That is also one reason I prefer Integer over Y/N for some applications.  

0 Likes