Our Airtable tracks the progress of legal documents through client submission, business team review, legal team review, client review, then completed. We want accurate reporting on the cumulative number of days that a document sits in each status. The challenge is that our process is NOT linear - documents may go to legal team review status, then to client review status, then back to legal team review for a few more days. We can’t anticipate how much back & forth will take place, so we can’t iron out the process to be linear with additional status columns.
When we use automations to timestamp each status change using the Last Modified Time field and the DATETIMEDIFF formula, we get incorrect data, since a second move to legal team review status, for example, will overwrite the first date(s) that the record was in legal team review.