Hi everyone,
I'm hoping someone here can help me (after spending hours of researching, I cannot find the solution to this).
I am working on a project around tracking certain items being sent out to certain providers and monitoring if we get anything back from the providers. However, the items are being sent out to multiple providers and sometimes one provider. I need a formula or a condition that calculates if everything is returned by the providers or provider it will say "complete" under the received all column.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item[/TD]
[TD]Provider 1[/TD]
[TD]Provider 2[/TD]
[TD]Provider 3[/TD]
[TD]Received all?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Sock[/TD]
[TD]Received[/TD]
[TD]Sent[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Shirts[/TD]
[TD][/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Computers[/TD]
[TD]Received[/TD]
[TD][/TD]
[TD]Sent[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Laptops[/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Shoes[/TD]
[TD]Received[/TD]
[TD][/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Currently, I have the formula in E2 as =If(and(B2="Received",D2="Received"),"Complete","") but it disregards cell C2. Is there a way to add C2 into the formula, but disregard if it is empty or says the word sent?
I'm hoping someone here can help me (after spending hours of researching, I cannot find the solution to this).
I am working on a project around tracking certain items being sent out to certain providers and monitoring if we get anything back from the providers. However, the items are being sent out to multiple providers and sometimes one provider. I need a formula or a condition that calculates if everything is returned by the providers or provider it will say "complete" under the received all column.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item[/TD]
[TD]Provider 1[/TD]
[TD]Provider 2[/TD]
[TD]Provider 3[/TD]
[TD]Received all?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Sock[/TD]
[TD]Received[/TD]
[TD]Sent[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Shirts[/TD]
[TD][/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Computers[/TD]
[TD]Received[/TD]
[TD][/TD]
[TD]Sent[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Laptops[/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Shoes[/TD]
[TD]Received[/TD]
[TD][/TD]
[TD]Received[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Currently, I have the formula in E2 as =If(and(B2="Received",D2="Received"),"Complete","") but it disregards cell C2. Is there a way to add C2 into the formula, but disregard if it is empty or says the word sent?