Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automatic creation of date of action

Topic Labels: Base design
433 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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