Hi @Suvrutt_Gurjar @Aurelien @
How can i fix this error.
Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)
ISBLANK(
FILTER(
""CAMPUS SCAN SHEET",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
),
"Already Scanned This Shipment","Wrong Gate Entry No"))
Expression 'ISBLANK( FILTER( ""CAMPUS SCAN SHEET", ([_THIS] = [GATE ENTRY NO]) ) - LIST([_THISROW]) ), "Already Scanned This Shipment","Wrong Gate Entry No"))' was unable to be parsed: Number of opened and closed parentheses does not match.
Valid If formula for column GATE ENTRY NO (Yes/No,List)
ISBLANK(
FILTER(
"Campus scan sheet",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
)
Note: This expression could impact performance.
((The list of values of column 'GATE ENTRY NO'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
....The value of column 'GATE ENTRY NO')) is empty
Test
open_in_new
Hi @Sirfyaad
What about this ?
Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)
IF(
ISNOTBLANK(
FILTER(
"CAMPUS SCAN SHEET",
[_THIS] = [GATE ENTRY NO]
)
- LIST([_THISROW])
),
"Already Scanned This Shipment",
"Wrong Gate Entry No")
)
Valid If formula for column GATE ENTRY NO (Yes/No,List)
ISBLANK(
FILTER(
"Campus scan sheet",
[_THIS] = [GATE ENTRY NO]
)
- LIST([_THISROW])
)
You can read the error message...
I forgot to remove one parenthesis. This one.
Hi @Aurelien
Both Expression are Done. but Duplicate error but showing why.
Valid If formula for column GATE ENTRY NO (Yes/No,List)
ISBLANK(
FILTER(
"CAMPUS SCAN SHEET",
[_THIS] = [GATE ENTRY NO]
)
- LIST([_THISROW])
)
Note: This expression could impact performance.
((The list of values of column 'GATE ENTRY NO'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
....The value of column 'GATE ENTRY NO')) is empty
Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)
IF(
ISNOTBLANK(
FILTER(
"CAMPUS SCAN SHEET",
[_THIS] = [GATE ENTRY NO]
)
- LIST([_THISROW])
),
"Already Scanned",
"Wrong Gate Entry No")
Note: This expression could impact performance.
IF this condition is true:
....This statement is false:
........((The list of values of column 'GATE ENTRY NO'
............from rows of table 'CAMPUS SCAN SHEET'
............where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
............The value of column 'GATE ENTRY NO')) is empty
THEN use the value of:
...."Already Scanned"
ELSE use the value of:
...."Wrong Gate Entry No"
question: as you have only one condition in the valid_if expression, why don't you just put :
"Already Scanned"
in your error message ?
If the user enters Wrong Gate Entry, then "Wrong Gate Entry No" has to be shown for him. And if someone re-enters one entry then "Already Scanned" will appear.
Thank you for the explanation.
The error message, with the IF() expression, suggests your valid_if expression can have two situations. Currently, it only deals with one.
You may want to make these two fields to match.
AND(NOT(
AND([_THIS]<1984990,
[_THIS]>1984990
)),
ISBLANK(
FILTER(
"CAMPUS SCAN SHEET",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
))
IFS (
NOT(
AND([_THIS]<1984990,
[_THIS]>1984990
)
),
"Invalid Gate Entry No",
ISBLANK(
FILTER(
"CAMPUS SCAN SHEET",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
),
"Already scan your shipment"
)
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |