Skip to main content

Automatic creation of date of action

  • September 5, 2021
  • 3 replies
  • 42 views
S

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

Kamille_Parks11
Forum|alt.badge.img+27

Turn the date field into a formula like so:

IF(
   {Field Name} = "done",
   LAST_MODIFIED_TIME({Field Name})
)
S
  • Stylianos_Beles
  • Author
  • New Participant
  • September 6, 2021

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

Justin_Barrett
Forum|alt.badge.img+21

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

Terms & ConditionsAccessibility statement