Help

If with checkbox not working

Topic Labels: Formulas
Solved
Jump to Solution
2599 14
cancel
Showing results for 
Search instead for 
Did you mean: 
Valentin_GUENIC
6 - Interface Innovator
6 - Interface Innovator

Hi everyone !
Here’s a very simple formula :
IF(
{Edition}=1,
{Genuine Console Family},
IF(
NOT(
AND(
{Accessories list},
{Games}
)
),
{Genuine Console Family}
)
)

I don’t know why, the first IF doesn’t work at all. I check the checkbox and nothing happens.
But, when Accessories list and Games have values, I can check and the field is fill with the right value (Genuine Console Family).

Thanks a lot for any help.

1 Solution

Accepted Solutions
Valentin_GUENIC
6 - Interface Innovator
6 - Interface Innovator

I made a mistake… and I’m sorry.
I forget to mention that I need to fill another field (hardwares) in order to have Genuine Family Console field not empty… so it works like a charm !
Thanks for helping my brain working :winking_face:

See Solution in Thread

14 Replies 14

I just tried your formula. It does work, but maybe you’ve got the logic wrong for the behaviour you want. What exactly are you trrying to achieve?

OK let me explain.
I want to display {Genuine Console Family} (another field content) if:

  • checkbox is checked
    OR
  • {Accessories list} AND {Games} are empty (both at the same time)

IF(
OR({Edition}=1,AND({Accessories list}="",
{Games}="")
),
{Genuine Console Family},
BLANK()
)

That’s assuming Accessories List and Games are both text fields.

I think your problem was applying NOT to an AND statement. Your AND statement was evaluating as TRUE if both Accessories and Games were not empty, and FALSE in all other instances. The NOT statement then reversed this. So it was FALSE when both Accessories and Games were not empty and TRUE for all other instances.

And they’re not text fields… :slightly_smiling_face:

You might need to change the Accessories List and Games evaluations then. Possibly to:

AND({Accessories list}=0,{Games}=0)

So I did test what you wrote… and still, when I check the checkbox, nothing is displayed in the field.
I don’t understand at all what is the problem.

What type of fields are Accessories List and Games?

Both are links to fields