We have a Monday board for tracking our paid consulting engagements that can last anywhere from one week to upwards of six to seven weeks. One of our metrics for this offering include tracking the average completion time for certain engagements.
I would like to be able to have either the timeline or the duration column automated to populate once the Date Completed column is filled out. I am looking for the number of days between [Date Assigned] and [Date Completed] without needing to fill out the timeline or duration column manually.
Currently I set the timeline for those engagements manually by selecting the dates that line up with what was entered into Date Assigned and Date Completed columns and the duration is filled out automatically. Is there any way to automate the timeline column based on two other date columns? Or is someone familiar with a better way to track this?