Forum Discussion
killwa16
Jul 26, 2024Copper Contributor
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 in the shipment as values.
Basically, what I want to create is a formula that will get the next shipment date for each product. If the date is past then it should tell me the next date. Or there is a better way of doing this, please do share. Thank you!
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")