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 |