IFS with Error

Hello,

Please help with the expression bellow

IFS(
AND(
ISBLANK(
[EXPEDITION DATE]),
ISBLANK(
[SHIPPING ARRIVAL DATE]),
ISBLANK(
[SHIPPING RECEPTION DATE])),“NOT SHIPPED”,
AND(
ISNOTBLANK(
[EXPEDITION DATE]),
ISBLANK(
[SHIPPING ARRIVAL DATE]),
ISBLANK(
[SHIPPING RECEPTION DATE])),“SHIPPED”,
AND(
ISNOTBLANK(
[EXPEDITION DATE]),
ISNOTBLANK(
[SHIPPING ARRIVAL DATE]),
ISBLANK(
[SHIPPING RECEPTION DATE])),“ARRIVED”,
AND(
ISNOTBLANK(
[EXPEDITION DATE]),
ISNOTBLANK(
[SHIPPING ARRIVAL DATE]),
ISNOTBLANK(
[SHIPPING RECEPTION DATE])),“RECIEVED”,
AND(
([EXPEDITION DATE])>TODAY()),
ISBLANK(
[SHIPPING ARRIVAL DATE]),
ISBLANK(
[SHIPPING RECEPTION DATE])),“BOOKED”,
)

Many thanks

0 2 260
2 REPLIES 2
Top Labels in this Space