Hi,
I am wondering if it's possible to check multiple variable are not blank, with multiple variable nested as Or.
something like this:
If(IsBlank(var_A) +
IsBlank(var_B) And
IsBlank(var_1 || var_2),
true, false)
Hi,
I am wondering if it's possible to check multiple variable are not blank, with multiple variable nested as Or.
something like this:
If(IsBlank(var_A) +
IsBlank(var_B) And
IsBlank(var_1 || var_2),
true, false)
Thanks, @mmbr1606
After some tweaking I Got it to work,
If(IsBlank(var_A)+
IsBlank(var_B) +
IsBlank(var_C) +
Or(IsBlank(Var_1) And IsBlank(var_2));
true; false)
Thanks for the response @mmbr1606,
I might not explained it right, With your example the Or part only works, if all within the Or part are not blank.
What I try to do is a couple of variables are seperatly filled, and combined with a nested group of variables of witch only one need to be filled, to give a true
hey @NielsNachtegaal
try this please:
If(
And(
IsBlank(var_A),
IsBlank(var_B),
Or(
IsBlank(var_1),
IsBlank(var_2)
)
),
true,
false
)
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
WarrenBelz
146,670
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,011
Most Valuable Professional