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

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”,
)

this one should be the solution

2 Likes

I would strongly encourage you to include a default statement as well. You do that by implementing the last condition/value pair as:

true, "Some Default Value"

in your case that might be:

true, "UNKNOWN"

This will make it much easier when problem troubleshooting to identify that your IFS() did not match any of the above criteria and that you need to look at the state of the other columns.

If you just let it default to blank, the tendency is to think that the system didn’t call your IFS() expression and you’ll spend hours trying to figure out why your expression didn’t execute until you finally realize that your columns were in a state that didn’t meet any of the IFS() criterion.

3 Likes