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.

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.