Hello -
I have a calendar board I am using to track our team’s PTO and would like to display a grouping by when the PTO is occurring. I initially tried grouping by my timeline field which works fine if the PTO is a single day, but for multiple days, it looks at the end date so an entry for M-F looks like it isn’t happening until Friday. I’d like to create a formula that provides similar values to the out of the box grouping by timeline (today, this week, last week, last month, past, etc.) by querying the proximity to today between the start and end date of the timeline field. Once I have that, I can then group by that formula field.
Is this something someone can help with?