Hello!
I would like to create a field that shows when (date and time) a record (task) has been marked as "Done". Here is what I have so far:
How do I create a formula and/or automation to do this?
TIA!
+17Hi!
You can create a "Last modified time" field and set it to trigger when the Status field is updated like this:
+4Hi!
You can create a "Last modified time" field and set it to trigger when the Status field is updated like this:
This autopopulates yesterday's date and time into the field, and I would like for completed date and time field to be empty until "done" is the status
+25This autopopulates yesterday's date and time into the field, and I would like for completed date and time field to be empty until "done" is the status
Hi,
You can use a formula
IF(Status='Done',LAST_MODIFIED_TIME(Status))It's a good solution when you know that once Status is 'Done' it doesn't changed, it works instantly and uses only formula.
If somebody change the Status, output will be blank again and date of last 'Done' is lost. So if you want to save this date, you need to add automation to copy this value to another field. Or you can setup automation to put current date in some field when The record matches condition ( Status='Done' )
+17This autopopulates yesterday's date and time into the field, and I would like for completed date and time field to be empty until "done" is the status
Ah, I see! In that case, @Alexey_Gusev 's solution below is prob best.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.