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:
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |