I need help with the formula for the following problem.
I have a list where you fill in a number of ordered items, and another column where you fill in how many of the items that are receieved.
Lets call them
I aldo have a Status column with 3 choices. The choices are:
- "Waiting for delivery"
- "Partly delivered"
I want to make the default value a calculated value based on number of ordered items compared to the receieved items.
if [ordered] = 100 and [receieved] = 0 then the status should be "Waiting for delivery" if [ordered] = 100 and [receieved] < [ordered] but > 0 then the status should be "Partly delivered" if[receieved] = [ordered] then the status should be "Complete"
I have tried the following but it does not seem to work (yes I suck at this):
=if([receieved]="0"),"Waiting for delivery",if(AND([received]<[ordered],[received]>0),"Partly delivered",if([received]=[ordered]),"Complete"