Help

Re: Automatic creation of date of action

988 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Stylianos_Beles
4 - Data Explorer
4 - Data Explorer

When I update a value inside a data cell ( for example from undone to done ) , is there any way for the date of action to be automatically inserted in separate new cell ?
Thanks in advance

3 Replies 3

Turn the date field into a formula like so:

IF(
   {Field Name} = "done",
   LAST_MODIFIED_TIME({Field Name})
)

Thanks , but it does not seem to work.
if(
{Status} = “done”,
LAST_MODIFIED_TIME({Status})
)

Welcome to the community, @Stylianos_Belesis! :grinning_face_with_big_eyes: Did you change “done” to the actual name of your field choice? Keep in mind that string comparisons are case sensitive, so “done” is not the same as “Done”. If it’s not a case issue, check to see if you have a space at the end of your single selection option; i.e. "done " won’t match “done”.