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]

Just add a Last Modified Time field to your table, and make the choice for it to only update when the collaborator field is modified.

[Lercio_Pinto]

Hello again Scott!
I feel so dumb… I totally forgot that existed. But If the field is empty I want it to be clear, not with the date it was deleted. Any ideas?

[ScottWorld]

Then, you could create a new formula field for that.

[Lercio_Pinto]

Hmm replacing the last modified field? Could you help me with the formula itself?

[Lercio_Pinto]

I managed to get it working but the Date “value” is shown like this: 2020-05-12T13:12:03.000Z
Is it possible to change the format?

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

[Mohamed_Swella1]

Hi @Lercio_Pinto,

Click on the top of the field, customize, then choose formatting, this should show you the option to format the date.

BR,
Mo

[Lercio_Pinto]

I get this message
“Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.”

[Mohamed_Swella1]

I got confused between your first post and your last one.

Try it like this

IF({delivered by},{Delivery date})

Is the field Delivery Date set as a date? Otherwise, you want Last Modified Time or not?

BR,
Mo

[Lercio_Pinto]

Currently at 3 Fields
Delivered by(Collaborator field)
Delivery date(Formula, picking up date from “Last Modified Time”)
Last Modified Time(Last modified of “Delivered by”)

Formula is:
IF({Delivered by}!="",{Last Modified Time},"")

If the vehicle was delivered by someone it gives me the date, if not, it show empty " ".
But the date the is showing like this: 2020-05-12T14:30:14.000Z
Only the Date shown by formula is messing up, the date shown by “Last Modified Time” is fine.