Combining 2 rules

[Clau-d12b]

Hey All,

I am trying to combine 2 rules on a button visibility

=FILTER(Users,"Users[Name]=%",$[SYS_USER])=0
AND
=if(ISBLANK($[Picklist]) = TRUE,TRUE,FALSE)

Before User can save the record both criterias need to match. Trying this for an hour without success.

=if(AND ISBLANK($[Picklist]) = TRUE,FILTER(Users,"Users[Name]=%",$[SYS_USER])=0)) ,TRUE,FALSE)

Thx for help
Claus

[Alyssa]

Hi @Clau-d12b,

I can show you how to write the formula, and in a simplified way.

You'll want to use the AND() function, with the syntax of AND(argument 1, argument 2, ...). This checks if each argument evaluates to true, so you do not need to use the IF() function to do this check.

So your formula would look like this:

=AND($[Picklist]="", FILTER(Users,"Users[Name]=%",$[SYS_USER])=0)

Let me know if this helps!

[Clau-d12b]

Hi Alyssa,
thx a lot for clarifying. It works perfectly.
Greetings from Germany

Claus

[Alyssa]

Hi @Clau-d12b,

Great! You're welcome, I'm always happy to help