I’m quite new to coda and I’m trying to pull information from one table (T1) to a new table (T2). T1 consists of two columns, one being a date and the other being simple numbers.
I’m trying to create a formula for T2 that sums these numbers with the condition that the date is within two weeks of today (relative to the user). I’ve tried filtering T1’s date range however T2 still pulls and sums all contents from T1, regardless of dates.
Any ideas or help would be appreciated. Thanks!