Good day! Relative Coda newbie here. And I’ve been so excited to use Coda for our company ever since I found out about it!!
Anyway, I’ve been struggling with a new doc I’m creating. I’ve created a sample here for everyone to see:
The gist is I have 3 tables,
Table0 : This is a lookup of items I’ll be referencing in the other 2 tables.
Table1 : This is a daily log of our factory’s produced items.
–2a) We produce multiple items in the factory.
–2b) The daily production differs everyday, and is not consistent.
–2c) We produce our items daily, with or without orders.
Table2 : This is a log of incoming orders.
–3a) Customers would request their items to be produced fresh. Hence, the Date start column tells us that the customer would like the items to be produced on a date not later than this date.
My question centers around: Table2’s Find Date Completed column.
How do I find the value of this column with the following given constraints: Table2’s Date start column AND Table1’s production log.
So, in the example data in the Sample Doc I shared above: the Find Date Completed column’s value should return 11/3/2020
Looking at Table1’s data, the cumulative QTY Produced of Item A from 11/1/2020 (Date Start) will reach or exceed Customer A’s QTY order (4 units) by 11/3/2020 (1.5+1.2+1.5 = 4.2 units)
But how do I translate this into a formula?
Thanks a bunch in advance!