Forum Discussion

killwa16's avatar
killwa16
Copper Contributor
Jul 26, 2024
Solved

Formula to look at the dates given a condition

Hello! I am stuck with this problem for quite some time now and I really need help.  I have this pivot table that has the product on the rows and the shipment dates on the column and the quantity i...
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jul 26, 2024

    killwa16 You may use nested FILTER() function.

    =@FILTER($B$1:$F$1,(FILTER($B$2:$F$13,$A$2:$A$13=$I2)>0)*($B$1:$F$1>=TODAY()),"No Shipment")

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Jul 26, 2024

killwa16 You may use nested FILTER() function.

=@FILTER($B$1:$F$1,(FILTER($B$2:$F$13,$A$2:$A$13=$I2)>0)*($B$1:$F$1>=TODAY()),"No Shipment")

 

 

  • killwa16's avatar
    killwa16
    Copper Contributor
    Jul 26, 2024
    OMG! thank you so much!

Resources