Formula When Collaborator added, add last time modified

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.

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.

1 Like

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:

1 Like

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.