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
LinkedIn
Twitter
