Error same type at my code

Hi, i’m using this appformula to validate a datetime column and it working:

ISBLANK(
        FILTER(
              "agenda",
               AND(
                             ([_THISROW].[STATUS]<>"Os Fechada"),
                  OR(
                    AND(
                               ([_THISROW].[montador] = [montador]),
                              ([_THISROW].[agenda] >= [agenda]),
                              ([_THISROW].[agenda] <= [Previsão de Término])
                              ),
                    AND( 
                               ([_THISROW].[agenda] <= [agenda]),
                               ([_THISROW].[Previsão de Término]>=[agenda])
                              )
                        ) 
                    )
               )
)

But i need if the user is admin the column is free to put any date, i’m trying it but not working:

if(lookup(useremail(),usuarios,email,permissao)=“ADM”,[_this],

ISBLANK(
FILTER(
“agenda”,
AND(
([_THISROW].[STATUS]<>“Os Fechada”),
OR(
AND(
([_THISROW].[montador] = [montador]),
([_THISROW].[agenda] >= [agenda]),
([_THISROW].[agenda] <= [Previsão de Término])
),
AND(
([_THISROW].[agenda] <= [agenda]),
([_THISROW].[Previsão de Término]>=[agenda])
)
)
)
)
)
)

i’m getting this error:

1 2 198
2 REPLIES 2
Top Labels in this Space