I need Help

[Sirfyaad]

Could you assist me in fixing this?

NOT(
OR(
AND(
ISNOTBLANK([AWB NO]),
ISNOTBLANK(
SELECT(
"Notification Not Met",
AND(
STARTSWITH([AWB NO], [Start Value]),
OR(
([CHANNEL] = [Channel met]),
AND(
ISBLANK([Channel]),
ISBLANK([Channel met])
)
)
)
)
)
),
AND(
ISNOTBLANK([AWB NO]),
ISNOTBLANK(
SELECT(
"Notification Not Met",
AND(
ENDSWITH([AWB NO], [End Value]),
OR(
([CHANNEL] = [Channel met]),
AND(
ISBLANK([Channel]),
ISBLANK([Channel met])
)
)
)
)
)
)
)
)

[StephenSaid]

What is the error you are getting?

 SELECT(
"Notification Not Met",
AND(
STARTSWITH([AWB NO], [Start Value]),
OR(
([CHANNEL] = [Channel met]),
AND(
ISBLANK([Channel]),
ISBLANK([Channel met])
)
)
)
)

The SELECT statement expects a dataset-column as the first parameter

[Sirfyaad]

---

@StephenSaid wrote:

What is the error you are getting?

 SELECT(
"Notification Not Met",
AND(
STARTSWITH([AWB NO], [Start Value]),
OR(
([CHANNEL] = [Channel met]),
AND(
ISBLANK([Channel]),
ISBLANK([Channel met])
)
)
)
)

The SELECT statement expects a dataset-column as the first parameter

---

And second expression 

[Sirfyaad]

@StephenSaid 

I would like to use the STARTSWITH() and ENDSWITH() functions together. Could you please guide me on how to implement them? I want the bot to trigger only if the values from STARTSWITH() and ENDSWITH() do not match the specified condition: [Channel] = [channel met].