Jun 24, 2020 05:34 PM
Well, Here’s the input. I have 2 table
Table 1: Clients orders
Table 2: Stocking Table. It has {Import Date} field.
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!
Jun 24, 2020 10:33 PM
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!
Jun 24, 2020 10:34 PM
You are welcome.
Maybe using Zapier would be easier then.