Formula

New Contributor

I an wanting to have the PR progress update with one of 3 options , but can only get two to work and assistance would be appreciated

 

             
Date PR ReceivedPurchase RequistionPR Progress PO IssuedPO Date  If G > than  00/01/1900 Complete 
01/07/20202004MDS1Issued for pricing2004 01115/07/2020 if B > 00/01/1900 Issued for pricing 
01/05/20202004MDS1Issued for pricing2004 01515/07/2020 if B <00/01/1900 Requisition not received
00/01/19002004MXB0Requisition not received2004 02103/09/2020      
00/01/19002004MDS0Requisition not received2004 02204/09/2020      
00/01/19002004MFL0Requisition not received0000000004/09/2020      
00/01/19002004MFX0Requisition not received2004 02410/09/2020      
00/01/19002004MFX0Requisition not received2004 03030/09/2020      
00/01/19002004MXB4Requisition not received2004 03502/10/2020      
00/01/19002004MFX5 0000000002/10/2020      
00/01/19002004MXB6 2004 05130/10/2020      
00/01/19002004MFX7 2004 05030/10/2020      
00/01/19002004FPC8 2004 04930/10/2020      
00/01/19002004FPC9 2004 04830/10/2020      
00/01/19002004MDS10 2004 05230/10/2020      
00/01/19002004MDS11 2004 05506/11/2020      
00/01/19002004FPC12 2004 06127/11/2020      
00/01/19002004FPC0 2004 10314/01/2021      
00/01/19002004LSU0 2004 LSU 00200/01/1900      
00/01/19002004 0 2004 LSU 00200/01/1900      
             

 

4 Replies

@Pete_H_63 

Is it possible to submit Excel file with data as in post instead of text?

File Attached
Apologies the first time I have used a community hub

@Pete_H_63 

Thank you for the file. Not sure I understood you correctly

image.png

Perhaps you mean column H, not column G and empty cells in column B instead of <00/01/1900.

Variant of formula is

=IF(H3>1, "Complete",
  IF(B3>1,"Issued for pricing",
          "Requisition not received")
)