I am having problems with syntax of below. Can anyone help me please.
Status:
IF([Order No]=โ0โ ,โRequestedโ,โOrderedโ)
This part works but when Order is received Status needed to change to โReceivedโ
so when [Qty Received]<> 0 Then Status = โReceivedโ
IF(([Order No] = โ0โ), โRequestedโ, IF(([Order No] = โ0โ), โOrderedโ, IF(([Qty Received] <> โ0โ), โReceivedโ, โ???โ)))
Also tried this;
IFS(([Order No])=โ0โ,โRequestedโ, ([Order No])<>โ0โ, โOrderedโ, ([Qty Received])<>โ0โ, โReceivedโ )
@Martina
You can try with this:
IFS(
[Order No]=0,"Requested",
TRUE,
IFS(
NOT([Qty Received]=0),"Received",
TRUE,"Ordered"
)
)
Thank you so much. This worked perfectly.
Or:
IF(
([Order No] = 0),
"Requested",
IF(
([Qty Received] <> 0),
"Received",
"Ordered"
)
)
or:
IFS(
([Order No] = 0),
"Requested",
([Qty Received] <> 0),
"Received",
TRUE,
"Ordered"
)
Thank you. I think I was making it more complicated than it had to be. One less problem to take into the weekend
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |