Hello, How can i resolve this expression? ...

AppSheet AppSheet Q&A
1

Hello,

How can i resolve this expression?

Thanks

2

AND([situacao]=“Ativo”,IN(USERSETTINGS(…),elementos[agrupamento])) Translate

3

@Aleksi_Alkio thanks but doesn’t work.

4

Glad you found the solution!

5

What is the result or error?

6

@Aleksi_Alkio

7

When you are using the value from the USERSETTINGS table, you should add that field name as well. The alert is asking that field name.

8

@Aleksi_Alkio ok, but i want to list the rows from one table that contains the same value of the USERSETTINGS value.

how can i do that?

9

Okay… AND([situacao]=“Ativo”,USERSETTINGS(…)=[agrupamento])

10

@Aleksi_Alkio thanks but i don´t get that.

11

May I ask what is the problem with my above formula? What is the goal for this formula? With that formula, it will show you all rows in a slice when both of those evaluations are true.

12

@Aleksi_Alkio Thanks, it works. On USERSETTINGS(…) missing USERSETTINGs(Agrupamento).

The correct is AND([situação]=“Ativo”, USERSETTINGS(Agrupamento)=[agrupamento])

Thanks again