Help

Re: Formula When Collaborator added, add last time modified

Solved
Jump to Solution
1116 2
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.

1 Solution

Accepted Solutions

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:

See Solution in Thread

11 Replies 11

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.

Lercio_Pinto
6 - Interface Innovator
6 - Interface Innovator

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

Lercio_Pinto
6 - Interface Innovator
6 - Interface Innovator

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.