Gallery
Share
Explore

icon picker
Planning and overlap

Based on a public twitter challenge ⤵️
⁠
The Coda Guy on Twitter / X
⚠️ Advanced @coda_hq formula challenge! ⚠️Can you create a column in a `Staffing Assignment` table that will read TRUE if a single employees start/end dates for an assignment overlap with any of their other personal projects?Full details in picture below!#nocode pic.twitter.com/CUu6zJG6Du— The Coda Guy (@thecodaguy) September 21, 2023
twitter.com
⁠
⁠

Employee
Project
start date
end date
is there overlap?
Jono & Scott
dates with overlap
1
The Coda Guy
Clean the kitchen
Jun 9, 2023
Sep 24, 2023
Destroy the Ant Hill
6/14/2023 → 9/24/2023: Destroy the Ant Hill
2
Darth Vader
Clean the kitchen
Jun 24, 2023
Jun 30, 2023
[  ]

3
The Coda Guy
Destroy the Ant Hill
Jun 14, 2023
Oct 12, 2023
Clean the kitchen
Destroy the Ant Hill
6/14/2023 → 9/24/2023: Clean the kitchen
9/29/2023 → 9/29/2023: Destroy the Ant Hill
4
Darth Vader
Cook the patatoes
Nov 9, 2023
Dec 14, 2023
[  ]

5
The Coda Guy
Cook the patatoes
Oct 13, 2023
Nov 4, 2023
[  ]

6
The Coda Guy
Destroy the Ant Hill
Sep 29, 2023
Sep 29, 2023
Destroy the Ant Hill
9/29/2023 → 9/29/2023: Destroy the Ant Hill
There are no rows in this table
⁠

1
2
Name
The Coda Guy
Darth Vader
There are no rows in this table
⁠



The related blog you find here ⤵️:
⁠
https://huizer.medium.com/how-to-check-overlap-in-coda-d5d48cbe3543
⁠
⁠


1
2
3
4
Name
Clean the kitchen
Destroy the Ant Hill
Cook the patatoes
​
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.