I have a column formula that works really well with one single caveat… It takes 10 seconds per new entry to calculate. When I add 10 new entries, the computer essentially freezes for everyone in the doc for ±2 minutes, which makes collaboration almost impossible.
The column that I’m working with has 500 entries and the formula tries to look for clashing/overlapping times for a specific resource. There’s a separate resource column with 100 entries.
The formula is:
thisTable.Filter( ([Day of the week]=thisRow.[Day of the week]) AND ([Resource]=thisRow.[Resource]) AND [This row resource not blank] AND (Status=Active) AND (thisRow.Status=Active) AND (thisRow.Project!=Project) AND ((thisRow.[Start] > [Start] AND thisRow.[Start] < End) OR ([Start]>thisRow.[Start] AND [Start]<thisRow.End) OR (thisRow.End > [Start] AND thisRow.End <End) OR (End>thisRow.[Start] AND End<thisRow.End) OR(thisRow.[Start]=[Start] AND thisRow.End=End)) )
Start = the start time
End = the end time
This row resource not blank = true/false (separate column that checks whether resource row is not blank)
Project - A “head” project, which this activity is part of.
Would love to learn how to make it more efficient!