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
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.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |