Forum Discussion
Run out Date Formula
Hey everyone! I'm needing some direction on calculating a run out date for some products I have. I will have screenshots below. I have up to 200 open orders on some items, I just can't seem to wrap ...
SnowMan55 Thank you so much for helping me out with this! Unfortunately, I am having a hard time setting the parameters for the equation to my data. Would you be able to help me out with translating your equation to the data I will attach? I would appreciate it greatly! I haven't run into any problems yet of having my data arrayed in Columns, I guess I'll cross that bridge when I get there.
As your table is shifted of a column compared to that of SnowMan55
In E2 :
=IFERROR(LET(p,G2:AS2,INDEX(p,,SUM((SCAN(0,p*ISEVEN(COLUMN(p)),LAMBDA(c,x,c+x))<C2)*1)+2)),"")
Here the table is supposed to stop at column AS. It's up to you to adapt
The SCAN function may not be available (#Name)