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
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |