Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Formula When Collaborator added, add last time modified

Topic Labels: Formulas
Solved
Jump to Solution
2484 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Lercio_Pinto
6 - Interface Innovator
6 - Interface Innovator

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.

11 Replies 11

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:

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