Skip to main content

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

Turn 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})

)

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”.

Reply


Terms & Conditions