Hi!
So I have a table with start and end date of each quarter, where the quarter is the display column. I have another table of projects that have a start/end date of each project. I would like to display, in a new column, all the quarters that the project lands in.
Here’s what I have so far, page. I partly worked on it already but I’m unsure how to get anything that runs more than 3 quarters. Or if there’s a better way to do this, please let me know. Thanks!
(you might need to request access to the page, the org is blocked to the public)
I’m terrible at the formula part, but I wonder if going at it from a calendar perspective would make more sense? So keeping that Start and end Date, and the formula will say “If the quarter span of dates falls within this span of dates, display it in this column” sort of thing
Or something? Maybe my thought can at least spark a new direction 
I am new to Coda myself and am really interested to see what the proper answer is!
I don’t have access to your doc, but you basically want to filter all the quarters that overlap with the start/end of your projects.
There are multiple posts about ‘Date overlaps’, just search a bit and I’m sure you’ll find a solution.
Hi @Pablo_DV thanks! Searching gave me inspiration I got it working
cc @Shannon_Bradley
2 Likes