Hello, I am attempting to track a start to finish date, with finish date unknown. However, we want the tracking number to be “live” until the finish date. Context: we want to know the number of days it takes for a vendor to send us a warranty replacement based on our submit date
I have created an automation based on date that starts the time tracking, I just need to have it rounded to the full day. So If I add the date today, it will show 1 (under a column I’ll name “Total Number of Days.” ) the number 1.
What if you set things up with two date columns (Submitted Date and Finished Date) both of which could be automated via automation.
When Status Changes to Submitted, then set Submitted Date to today
When Status Changes to Finished, then set Finished Date to today.
Then you would need a formula column which can calculate the number of days (or work days) between submitted date and finished date. You would not need to use the time tracking column for this method and the dates will be whole without an additional step of needing to round them.
The formula would look something like this:
This is what this would look like on your board.
Let me know if you have any questions while setting this up!
Thank you for the suggestion! I attempted to do what you said and it worked as designed. However, we would like to have a running day count in real time.
Our vendors are being really slow with sending out warranty replacements. So we are trying to see how many days it has been sitting in the submitted status so the owners can easily see the tally of X days.
Then once it’s closed we will have the set number of days that will create and average at the bottom.
haha