Dates within a sum formula

Hi there!

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!

Dear @Alex_Matos great to have you in the community :handshake:

This means that you will filter the date column where the [date] is smaller or equal then “today + 14 days” AND [date] is bigger or equal then today

Hi @Jean_Pierre_Traets

Thanks so much!