Group By using Hidden Formula RegexExtract

Following conversation from WHILE loop implementation I thought to make a separate post showing how to create a GroupBy() formula that bypasses the Outer CurrentValue restraint.

Warning: This uses hidden formula and thus can break at anytime. I also generally don’t recommend this pattern as the problem you want to solve generally can be solved differently in a separate table with recursive formula. (I used it to be able to construct a Gantt Chart).

Related issues:



This is excellent - “GroupBy()” is such a powerful concept and would allow incredible flexibility in Coda, thank you for putting this together!