I want make a task and send email with filter kriteria,
someone can helpme...
i'm use this formula, but can't work :
Select(User[Email],
And(
[Email Automation]=Ya,
CONTAINS(USER[AKSES JOB SITE],[_THISROW].[SITE]),
CONTAINS(USER[AKSES MENU],VALIDATOR)
)
)
and i also try this :
Select(User[Email],
And(
[Email Automation]=Ya,
in([Site],[Akses Job Site]),
IN("Validator",[AKSES MENU])
))
@ADAJALAN wrote:
Select(User[Email],
And(
[Email Automation]=Ya,
in([Site],[Akses Job Site]),
IN("Validator",[AKSES MENU]))
IN() requires the 2nd arg to be a List. Are [Askes Job Site] and [AKSES MENU] Lists?
https://help.appsheet.com/en/articles/2357277-in
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |