Combining 2 rules

Hey All,

I am trying to combine 2 rules on a button visibility

=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

1 Like

Hi @Clau-d12b,

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

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! :honeybee:


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



Hi @Clau-d12b,

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.