I have a team calendar board for tracking PTO/company holidays, which has a formula counting the number of Total Days (minus weekends) for each entry. I’m also working on a sprint capacity planner board and plan to pull in the pto and company holidays from from a connection and mirror (total days) so that I can deduct from each team member’s expected capacity. The challenge I have is that the pto/holiday tracker entries do not all align with the 2-week sprint cycles (Wed-Tues) so the mirror column dates are going to throw off the calculations. I would like to create a formula that looks the timeline column in the Sprint Capacity Planner board and the mirror column from the Calendar board and calculates the number of days that those two overlap. Then I can create another formula that deducts the new formula column from my starting capacity column. Any help would be greatly appreciated.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Formula help - Calculate number of days that one timeline column overlaps another timeline column | 0 | 3 | January 13, 2025 | |
| Formula Help - Calculate days between timeline column when spanning two calendar years | 1 | 8 | January 15, 2025 | |
| Calculate workdays in a timeline column when account shows weekends | 1 | 869 | November 16, 2023 | |
| Help with Formula | 4 | 58 | October 18, 2024 | |
| Exclude weekends from formula column: Day Count | 17 | 14130 | July 21, 2020 |