We’ve created a “Sprint Board” that contains a sprint number, start date, end date, and timeline.
On our portoflio board, our subitems to projects we use a connected board column to “select sprints” and the timeline builds from earliest to latest.
However, we are using a different timeline within the subitem for our workload, Gantt, and other views since not all teams work in sprints.
I am looking for a way to take this mirrored timeline (earliest and latest) and automate an update to the other Timeline field. (It’s ok if the timeline changes and the sprint timeline doesn’t reflect appropriately.)
A few things I’ve tried:
- When multiple items are selected, I know it’s not a single object, but a multi-object and Monday is displaying a specific item of that data set- this prevents most normal automations from working.
- Use a formula to copy the date mirror column to capture current date, and automate off the formula
-
Each sprint row has a start and end date as a date column
Formula [form_s_start_date] = DATE_FORMAT({s.end})
-
if (trigger) [form_s_start_date] = {timeline#start}
-
- Same as the above but copy [form_s_start_date] → [new_start_date]
- Take the mirror column, use a formula to pull the date value out, use an automation to take that value and apply to another normal date field (then take that normal date field and push to the timeline ahhhhh)
I’ve tried several different 3rd party apps- since we’re working in sub-items, mirror column, and multi-selected items, many apps don’t apply.
I’m not opposed to a 3rd party app, but seems like I may have to brush up on my Python and write something myself….