Help

Need help to find formula for lookup

Topic Labels: Formulas
2783 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Kendy511
6 - Interface Innovator
6 - Interface Innovator

Well, Here’s the input. I have 2 table
Table 1: Clients orders
Table 2: Stocking Table. It has {Import Date} field.
Annotation 2020-06-25 073358
The question 's for {Sold out (days)} field
i wanna calculate the period of a Package sold by the last day sell out (which lookup in table 1) minimus {Import Date}. So which formulas should i use in this situation ?

Hope your guide can help!

11 Replies 11

Wow, seem complicated script. I think i must seem times to read and learn how to figure out this, not knowing anything about code or scripts .
I’m really appreciate your help. Thank you so much!

You are welcome.

Maybe using Zapier would be easier then.