Is it possible to record date on status change without date resetting when I change status? I am utilizing a board view for a kanban board and I basically want to have a date to be recorded at every stage.
Currently using a formula like this:
if(prop("Status") == "Done", formatDate(now(), "dddd, MMMM Do"), "")
But resetting of dates on status changes occurs.
Example, if I wanted to calculate the duration of task, I want to have the date I start working on a task (moving a task to the in progress column), and the date I move a task to the "done" column.
I need the dates to stay and not reset when I move the board view block into another column. This is because I want to utilize the "dateBetween()" function to calculate the duration of the task by utilizing the "in progress" and "done" dates.