Found some older posts that this is impossible, but hoping there might be a solution within the last two years:
I am creating a “phone sheet” within Airtable, essentially a tracking list of all the outgoing and incoming calls. My end goal is to have a field that will show last time I update a record’s “status” column (from incoming to outgoing, and vice versa). But I would also like to be able to manually overwrite the time… up until the next time I change the status, therefore going back to the automatic last modified time.
A case study: I receive a voicemail that some left an incoming call at 10:00am. It is now 3:00pm, so I would need to modify the record and then manually back-date the last call to have been at 10:00am.
Is there a formula function that would allow for this? Or would this be better suited for an automation?
Thank you - open to any suggestions!