Formula When Collaborator added, add last time modified

[Lercio_Pinto]

Hello,
I have 2 fields, Collaborator and Formula. When I select a collaborator(any) I want the formula to show last modified time.

Similar to this(this is for a checkbox, so it doesn’t work):
IF({PAGO} = 1, LAST_MODIFIED_TIME({PAGO}))

I have been messing arround with the formula but to no sucess.
Thank you in advance.

[ScottWorld · Accepted solution]

Lercio_Pinto:

My current formula:
IF({delivered by}!="",{Delivery date},"")

Change it to something like this:

IF({Delivered By},DATETIME_FORMAT({Delivery Date},'M/D/YYYY'),"")

And all the supported format specifiers for DATETIME_FORMAT are listed here:

Airtable - Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...

[Lercio_Pinto]

It is working! Thank you very much :winking_face:
Fantastic.