I don't know what is wrong in this. Please tell me what mistakes are there so that I can correct them.
OR(
IN(
USEREMAIL(),
FILTER(
"ENTRY ALLOWED EMAIL LIST",
TRUE
)[_ComputedUsersmail Log]
),
ISNOTBLANK(
FILTER(
"Entry Allowed List",
AND(
[REVERSE AWB NO] = [_THISROW].[AWB NO],
[COURIER CHANNEL] = [_THISROW].[CHANNEL]
)
)
)
)
I need help pls @Suvrutt_Gurjar @AleksiAlkio
In the expression below
IN(
USEREMAIL(),
FILTER(
"ENTRY ALLOWED EMAIL LIST",
TRUE
)[_ComputedUsersmail Log]
)
[_ComputedUsersmail Log] is an extra element. It does not fit in the IN() statement.
The error message is clearly saying that.
hi You need to share table names and columns
User | Count |
---|---|
15 | |
11 | |
9 | |
8 | |
4 |