I’m working with a client using the multi-level board structure and ran into a limitation with the Timeline column and the Formula column.
Their setup is:
-
A project board created from a template
-
Each item has two timeline columns:
-
Timeline (current schedule)
-
Baseline Timeline (created later as a snapshot baseline)
-
-
When a baseline timeline is added, there’s a ‘Difference’ column that comes with it by default. It calculates the difference between the end date of the baseline timeline and the end date of the current timeline. It uses the formula:
DAYS({Baseline Timeline#End}, {Timeline#End})
However, in multi-level boards, the Timeline column and the baseline column are not supported in the Formula column, so {Timeline#End} and {Baseline Timeline#End} cannot be referenced.
Because each project board is created from a template and the baseline is only created later, we are trying to avoid solutions that require:
-
manually adding helper columns per board
-
manually adding automations per board
-
external integrations just to read timeline dates per board
Our goal is a scalable template-based solution that works across many project boards.
Questions:
-
Is there any supported way to reference Timeline start/end dates in formulas on multi-level boards?
-
Is there a recommended approach from monday for calculating baseline vs current schedule variance in this structure?
-
Are there any upcoming improvements planned for Formula support with Timeline columns in multi-level boards?
Any guidance or recommended architecture for this use case would be helpful.
Thanks.