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
Automatic creation of date of action
This topic has been closed for replies.
+27Turn the date field into a formula like so:
IF(
{Field Name} = "done",
LAST_MODIFIED_TIME({Field Name})
)
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})
)
+21Thanks , 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”.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.