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….
Welcome to the community! What I understand you are looking for is available in an app called Rollup Subitems. It takes the timeline (or date) column from the subitems and put it (earliest to latest as an option) in a normal timeline column in the parent item. As this is not a mirror you can use the same timeline column you use in the parent items, or create another one if needed. The app also support filtering to filter which subitems take into account.
Hello Bas, appreciate the response. However, I’m not looking to move the timeline into the parent column, but a different column within the same row/item.
I then have two formula columns to take the LEFT and RIGHT 10 characters to capture the earliest and latest (so far, it always orders this earliest to latest.)
FORMAT_DATE(LEFT({Mirror timeline to text}, 10))
FORMAT_DATE(RIGHT({Mirror timeline to text}, 10))
Finally, I have a workflow that triggers when Mirror timeline to text changes. This uses the “Text to Date” function to take the text from each of the above columns and cast the result to a new timeline.
Currently, it takes about 30 seconds from connected column change → final timeline change. I’m working with my CS rep to see if there’s a better way, but I’m not sure there is.
