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” )
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |