LinkedIn
Twitter
Buenas noches estoy buscando una fórmula para filtrar una rebanada con 2 condiciones …
Por un lado use :
in ( useremail(), operadoras[ID operadoras])
Y por otro lado use :
Today<[fecha coordinada]
Necesito unirlos y aunque he probado con and
mi problema es que siempre me cuesta unir las ideas en fórmulas y coincidir con el idioma ya que no tengo conocimientos de programación y hay cosas que me cuesta entender 
no sé cuándo usan punto coma comillas paréntesis 
el único que estoy segura es que los corchetes son para las columnas 
Welcome to the community !
You may want to write in English for faster response, and if you are using the Google Translate extension: you may want to disable it.
About your question:
You can use the AND statement.
So, your row filter condition will be:
AND(
IN ( USEREMAIL(), [ID operadoras]),
TODAY()<[fecha coordinada]
)
About that:
To make it short:
- tableName[column] ==> list of all the values in the column of the table
- [column] ==> the column value, you got it
- [parentColumnOfTypeRef].[columnInTheParentTable] ==> get the value from a “parent” table, from a child table that has a column of type Ref, refererring to the parent table. Example: plates in a menu: plate are children, menu is parent ==> [Menu].[Price] will be the price
About this:
You may want to use a security filter.
Most of documentation is here:
It is well done and organized, in the search bar you may find useful content.
Also, in the community, provided you type your search in english you will probably find an answer to your question.
Here is a useful post:
Let us know if you succeed into building your conditions
