I am updating my array formula but the updated formula is erring out.
Original formula: =ARRAYFORMULA(IF(TODAY()>O2:O,"Past due",IF(TODAY()<O2:O-7,"Upcoming due date","Due this week")))
Updated formula: =ARRAYFORMULA(IF(ISBLANK(O2:O),"Not Started",IF(I2:I="Delivered","Delivered",IF(((TODAY()>O2:O)*(I2:I<>Delivered,"Past due",IF(TODAY()<O2:O-7,"Upcoming due date","Due this week")))))))
What I want this formula to do is:
- If Column O is blank, display text "Not Started"
- If Column O is not blank and today's date is greater than Column O AND Column I doesn't equal "Delivered", display text "Past Due"
- If Column I is "Delivered", display text "Delivered"
- IF(TODAY()<O2:O-7,"Upcoming due date","Due this week"
I am sharing my workbook, URL hyperlink available. The formula will live in Column AE "Due Week". Assistance needed and appreciated.
Aucun commentaire:
Enregistrer un commentaire