Formula When Collaborator added, add last time modified

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.

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?

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

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

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},"")

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

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

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

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.

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